January 31, 2012 at 7:14 am
Hello..
I need help with connecting to a newly created SQL server. I have always been able to connect to an SQL server provided the details like login and pwd are provided to me.
But this time the issue is slightly different. An SQL server instance has been created for me and i'm the admin on the VM where it's installed.
Now... how do i proceed with creating login and pwd. I am unable to connect to the server and it is asking for login credentials. HOw do i access it. 🙁
Please help. I am actually new to dealing with SQL server configs.
Thanks sooooo much!
Sonia
January 31, 2012 at 7:25 am
Who installed the SQL Server instance?
They should have appointed users to have admin privileges.
Is Mixed Authentication turned on? Is the sa account available?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 31, 2012 at 7:31 am
By default, SQL Server installation will be:
•In Windows Authentication Mode
•SA disabled
•And admin rights were given to only one account (user who installed SQL Server).
Saying all that, you need to request for privileges to connect to SQL Server. Please check with the guy who installed SQL Server on VM.
January 31, 2012 at 7:36 am
Hello! Thanks for replying.
My Network Engg in the US has done it for me.
He has just provided me with the instance name saying that i am an Admin there.
I have no idea about the rest. I have attached a screenshot of the error i get.
What should i be asking him? Can you you help me with this please.
Thanks!
January 31, 2012 at 7:37 am
soniaj (1/31/2012)
Hello! Thanks for replying.My Network Engg in the US has done it for me.
He has just provided me with the instance name saying that i am an Admin there.
I have no idea about the rest. I have attached a screenshot of the error i get.
What should i be asking him? Can you you help me with this please.
Thanks!
Run SQL Server Configuration Manager and see if the TCP/IP protocol is enabled for the SQL Server service.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 31, 2012 at 7:47 am
Looks like i dont have the SQL Server Configuration Manager installed. I dont see it under configuration tools.
January 31, 2012 at 7:52 am
Few quick checks:
•Can you ping to Server (VM)?
•Please verify the firewall. You need to add exception for default port 1433.
January 31, 2012 at 10:49 am
soniaj (1/31/2012)
Looks like i dont have the SQL Server Configuration Manager installed. I dont see it under configuration tools.
Are you checking on the server or on your own machine?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply