Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Strange experience in SQL 2008 when connecting
Message
From
29/06/2009 14:08:21
Peter Wagner
Point Informática Ltda.
Limeira, Brazil
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
Application:
Desktop
Miscellaneous
Thread ID:
01408945
Message ID:
01409148
Views:
52
Sergey,
Yes I have a default instance of SQL Server, but it's a SQL 2000, and during instalation of SQL 2008, the only option was to use a instance other than the default.

But I came out with a way to connect to the SQL 2008 instance without a error and SQL prompt form for the connection.
I got it using this string
cStringConnect =("Driver={SQL Server Native Client 10.0}; Server=192.168.1.2\SQL10; UID=sa; PWD=zqt321ploc; Database=AdventureWorks; Network Library=DBMSSOCN")
nID = SQLStringConnect(cStringConnect)
?nid
=SQLDISCONNECT(0)
I see it as an inconsistence of MS, now we have to remove "Address=192.168.1.2,1433" to establish a connection...
My only question is, and if someone wants to use other port?



>Do you have default instance of SQL Server on that server?
>
>>I tried this, but it shows an error message and then the SQL connection prompt form, if I just click the OK button in the SQL connection prompt form, the connection is established.
>>
>>It's very strange, I'm not changing anything, just clik the OK button, why it can't pass direct without showing the error and the SQL connection prompt form like when I make a connection defining "Server=BOSS2000\SQL10"
>>
>>I realy like to know what I'm missing here.
>>
>>The error message returned is:
>>---------------------------
>>Microsoft SQL Server Login
>>---------------------------
>>Connection failed:
>>SQLState: '08004'
>>SQL Server Error: 4060
>>Server rejected the connection; Access to selected database has been denied
>>Connection failed:
>>SQLState: '28000'
>>SQL Server Error: 18456
>>[Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'sa'.
>>
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform