|
-
Mar 29th, 2008, 08:08 AM
#1
Thread Starter
Lively Member
Unable to connect to sqlserver2005
Hello
I am new to SQL Server 2005 database and I can't connect to the server on the web, it works only on localhost.
I am using ADO and the connection string looks like this
Driver={SQL Native Client};Server=ServerIP\SQLEXPRESS;Database=DatabaseName;Trusted_Connection=yes;
When trying to connect I get the following error:
[Microsoft][SQL Native Client]SQL Network Interfaces: Error Locating Server/Instance Specified[xFFFFFFFF].
-
Mar 29th, 2008, 12:21 PM
#2
Re: Unable to connect to sqlserver2005
If it can't locate it then I would submit you connection string is in error.
-
Mar 29th, 2008, 01:20 PM
#3
Re: Unable to connect to sqlserver2005
Verily, I submit the same as my partial-namesake brother here. Check if you have the correct server name. The correct instance name. Firewall connections.
-
Mar 29th, 2008, 05:18 PM
#4
Thread Starter
Lively Member
Re: Unable to connect to sqlserver2005
The server name is OK...there's something else wring but I really can imagine what.....
Cound there be a problem in the sql server configuration?
-
Mar 29th, 2008, 06:58 PM
#5
Re: Unable to connect to sqlserver2005
Can you check the configuration in SQL Server Surface Area Configuration?
-
Mar 30th, 2008, 04:09 AM
#6
Re: Unable to connect to sqlserver2005
Is it setup to allow remote connections?
-
Mar 31st, 2008, 11:38 AM
#7
Member
Re: Unable to connect to sqlserver2005
is the SQL Browser service running?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|