Printable View
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].
If it can't locate it then I would submit you connection string is in error.
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.
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?
Can you check the configuration in SQL Server Surface Area Configuration?
Is it setup to allow remote connections?
is the SQL Browser service running?