1
vote
0answers
770 views

SQL Server 2008 R2 Express connection error

Hi I'm having issues with SQL connection for a client PC We have software that uses SQL database, and I have just updated from SQL2005 to SQL2008 We have 5 pcs: 2 x vista (32 bit) 2 x win7 (64bit) ...
-1
votes
1answer
131 views

SQL server ODBC connection for Active Directory user who doesn't log in to the windows

Do you think it is possible to create a SQL server ODBC Connection for an active directory user who doesn't log in into the windows. Ideally this type of users will be used in the batch process. So, ...
1
vote
1answer
172 views

Managing mass SQL Server ODBC Changes when migrating to a new SQL Server

How do you manage changing out a SQL Server and updating all the clients that connect to it to point to the new server? If I have SQLSERVER1, then buy new hardware and call the new server SQLSERVER2 ...
0
votes
1answer
182 views

Multiline statements via ODBC fail

I have written an ODBC wrapper in C++ and use it to execute queries, bind results and return data sets. Everything appears to work fine and I have been using it for a long time for single line ...
2
votes
1answer
2k views

Is TCP/IP required to connect to SQL Server 2008R2 with ODBC over a LAN *NOT* the internet

I have read one two three related threads but im not clear if SQL Server 2008 needs TCP/IP to make this work. Can it not accomplish with a pipe? I would prefer not to open up the machine to the ...
1
vote
1answer
143 views

Installing Sql Server 2008 Express edition installation removes ODBC configurations

My company distributes an application that requires Sql Server 2008 R2 Express Edition. We use the Microsoft Offline installer for Sql and make exstensive use of the command line switches to get the ...
0
votes
0answers
619 views

SQL Server 2008 Server-Side “Invalid userid” (Error 18456, Severity: 14, State: 5)

Errors Database administrators report Microsoft SQL Server 2008 server-side error "Invalid Login" (error 18456, Severity: 14, State: 5). Error examples from the server log: Dec 1 2010 10:12AM - ...
0
votes
1answer
590 views

Credentials work for SSMS but not (ODBC) LogParser script

Via SSMS I'm able to connect and navigate the server/db in question. but trying to connect via a logparser script the same credentials fail. I'm trying to execute this from the same box on which the ...
0
votes
2answers
5k views

Error creating ODBC connection to SQL Server 2008 Express

When creating a System DSN, I get the error: Connection failed: SQLState: '08001' SQL Server Error: 2 [Microsoft][SQL Server Native Client 10.0]Named Pipes Provider: Could not open a connection to ...
0
votes
1answer
569 views

Access to SQL 2008 Server with ODBC

what do you think about using an SQL-ODBC-driver (SQLSRV32.DLL) with the name 'SQL SERVER' for accessing a SQL Server 2008 Server database? A first look shows that it works but is there something ...
2
votes
3answers
6k views

User cannot access a system DSN on Windows Server 2008

We run our SQL Server services using a low privileged domain account. That account is NOT a local admin on the OS. Only access I give the user account is assigned during install of SQL: full control ...
0
votes
2answers
1k views

Only allow ability to read the views for a particular SQL Server user over ODBC

Newbie question: I have a designer who reads information from a SQL Server [2008] database. I've setup a few views for him to pull his data from and granted his user a member of the db_dataread ...