General information
Forum:
Microsoft SQL Server
Environment versions
SQL Server:
SQL Server 2008
>Hi,
>
>I've installed SQL Express 2008 R2 on a server and created a named instance: SQLExpress.
>
>In trying to connect to this server from PCs on the network I get this error during setting up an ODBC connection:
>
>Connection failed:
>SQLState: '01000'
>SQL Server Error: 11004
>[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect())
>Connection failed:
>SQLState: '08001'
>SQL Server Error: 6
>[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not found
>
>I have:
>
>1. ensured that ports 1433 and 1434 are open in the firewall on the server
>
>2. Ensured the SQL Browser service is running
>
>3. Double checked the name of the server (GFSL01\SQLExpress) by looking in SSMS
>
>4. Ensured that remote connections are allowed by looking at the Server Properties in SSMS
>
>What else could I be missing?
Windows OS permissions for the client machine to access the server ?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only