General information
Forum:
Microsoft SQL Server
Environment versions
SQL Server:
SQL Server 2008
Hi Frank,
When installing Express be sure you selected Network Service user, not admin or another. If you select admin for user, you can access SQL from server but not from clients. SQL Express is asking user during installation, care about that.
>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?
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