New SQL Server Express Installation
-
I'm in the process of bringing up a new SQL Server Express server for a migration. I'm able to ping the server from my laptop. I'm able to RDP into the server and connect to the databases as an Admin using SQL Server Management Studio. However, I am not able to connect to the database from SQL Server Management Studio on my laptop.
Any ideas?
I've done a one-for-one comparison between the existing server and the new one and confirmed that all of the Logins and permissions are identical.
-
SQL express, by default, does not allow remote connections, you very likely need to change that, and also go to SQL configuration and enable TCP-IP
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
1. Allow Remote Connection is enabled
2. My domain account has login permissions
3. TCP/IP is enabled using 1433
If it's any help, I'm also having problems with IIS on the same machine connecting to the instance.
-
In that case, if both iis and sql are blocked, its probably te wi dows firewall. Add two differen exceptio s, one for port 1433 and another for port 80 i assume. I dont have screenshots for that but its in the advanced tab of windows firewall i believe
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply