June 15, 2011 at 9:46 am
I have build one new SQL Server for our development environment under sub domain (Created a subdomain in the primary domain forest).
Configuration:
Operating system: Windows 2008 R2 SP2
SQL Server version: SQL Server 2008 Enterprize (NOT R2)
Server Environment: VM Ware
The installation was success and can create large databases as well. I can able to login the SQL Server through RDC (Remote desktop Connection) using both Windows Authentication and/Or SQL server user
Problem:
Though I can able to login using RDP. I CANNOT connect the serve from other PCc using SQL Server management studio. I tried giving all the combination of Database engine names, but no luck. I can able to ping or browse the server, but problem is in the SQL Server CONNECTION
Please shed some light on this. What kind of settings I should check? Your help is highly appreciated
Thanks,
Raj
June 15, 2011 at 9:51 am
What is the error are you getting?
A.J.
DBA with an attitude
June 15, 2011 at 9:57 am
A.J. Wilbur (6/15/2011)
What is the error are you getting?
Thanks for the reply
The common error message:
TITLE: Connect to Server
------------------------------
Cannot connect to rs-srv-devsql01\sqldev01.
------------------------------
ADDITIONAL INFORMATION:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
I am not a well experienced DBA (But having good experience in SQL Server programming) and just started to do some DBA activities due to the nature of the work.
Do I need to specifically set some settings in order to connect by remote (in same network)
June 16, 2011 at 12:01 am
what is the name of Instance or you have installed Default Instance ?
Can you connect SSMS (SQL Server Management Studio) on the same server ?
Are you using IP or Domain Name ?
Have you changed the default Port ?
Browser Service of SQL Server is running if you are using Named Instance ?
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
June 16, 2011 at 2:15 am
check that in conf.manager you have the relevant services enabled.
June 16, 2011 at 8:40 am
Syed Jahanzaib Bin hassan (6/16/2011)
what is the name of Instance or you have installed Default Instance ?Can you connect SSMS (SQL Server Management Studio) on the same server ?
Are you using IP or Domain Name ?
Have you changed the default Port ?
Browser Service of SQL Server is running if you are using Named Instance ?
Thanks Syed for trying to help me. Please have a look my answers
1. Yes, I am able to connect the server using SSMS on the server without having any issues
2. I am using IP
3. No; I did not change the default port
4. YEs, Browser service is running
I am trying all the options...no luck yet and challenging me
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply