April 17, 2011 at 8:26 am
I installed sql 2008 r2 on windows server 2008 r2 enterprize edition.
SQL installed smoothly but when I open the SQL server manager, it is not able to connect to default instance. After 1st attempt it says you can connect to 'local' in data base engine
will somebody help me in this issue?
I am connecting from the same computer not the remote
thanks in advance
Raj
April 17, 2011 at 12:48 pm
First of all check the SQL Server service is started or not in the SERVICES then open the SQL Server configuration manager then check protocols as well like
TCP/IP
SHARED MEMORY
NAMED PIPE
If any one of them is not started then start it and then restart the SQL Server service,which user you are using to connect the sql Server
Regards,
Syed Jahanzaib Bin Hassan
MCTS|MCITP|OCA|OCP|OCE|SCJP|IBMCDBA
My Blog
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
April 17, 2011 at 1:03 pm
Hi,
1st check the correct instance name or try from Ip, check all SQL services, if not started start the services or once you restart the server....it will work....
April 18, 2011 at 7:55 am
You probably need to go into the Windows Firewall on the server and add an exception for port 1433 or if you changed the default port for SQL Server to listen on you need to make an exception for that port instead. I had to do this with my R2 install.
April 18, 2011 at 7:00 pm
I tried TCP/IP
SHARED MEMORY
NAMED PIPE
all are running
tried to check the instance name but no luck at all
check in firewall but did not know how to do it?
will some body help?
thanks in advance,
Raj
April 19, 2011 at 3:37 am
Did you try specifying IP Address while connecting to the server.
Are you trying to connect directly from the Host Server, if yes, try to connect using sqlcmd.
sqlcmd -S<servername> -E
April 19, 2011 at 5:35 am
Raj, If you have installed SQL Server on your local machine, you have to add name that you have given to your computer.
ComputerName\YourSQLInstanceName
More info on my blog:
http://www.bitipsntricks.com/?p=66#more-66
To identify your computer name:
http://www.bitipsntricks.com/?p=59
Hope this helps,
regards
Natraj
April 19, 2011 at 5:43 am
Default name and default port do not required to mention in the connection you can use (.),LOCAL and System name only
You should first check the connectivity on the same server with the help of SQL Server Management studio and sqlcmd as mentioned by rishikapoor then you will for remote connectivity
There are 2 types of Protocols Protocol for Instance and Protocol for Client as shown in attachement
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply