Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
indrajit_sql
Starting Member
1 Post |
 Posted - 2011-11-19 : 22:08:38
|
| Hello,I am new to SQL Server and just installed an instance of SQL Server successfully. I need to set up an ODBC connection for one of my application to use it. Since the PC is running on 64-bit I use odbcad32 from C:\Windows\SysWOW64 folder. If I choose With SQL Server authentication using login id and password what is the user id and password I need to use because I did not create any user id while installing the SQL Server. When I use windows authentication instead.I am getting error:SQLState - 01000 SQL Error 2 Connection Open andSQLState - 08001 SQL Error 17 SQL Server does not exist or access denied |
|
|
alakiran
Starting Member
14 Posts |
Posted - 2011-11-28 : 17:44:39
|
| You should create a new sql login & specify the password and grant the required rights by connecting to the management studio . |
 |
|
|
|
|
|
ODBC Set Up for SQL Server 2008