Not able to connect to ssms

Question

Post reply

Not able to connect to ssms

sql_novice_2007

Hall of Fame

Points: 3307
More actions
August 17, 2011 at 10:23 am

#255682

Hi I have admin privelege on windows server but not able to connect to sql server instance using SSMS.
Where Can I give the access to sqlserver?
Thanks.

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

s-sql SSCommitted Points: 1970 More actions · Answer 1

s-sql

SSCommitted

Points: 1970

August 17, 2011 at 10:34 am

#1369732

Please ensure "SQL Server services" are running.

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 2

I'm assume that you can connect locally?

Make sure that remote connections check box is checked and that TCP/IP is enabled.

For instructions refer to the following

http://www.sqlservercentral.com/Forums/Topic1085068-391-1.aspx

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

Is it a named instance? How are you trying to connect? Do you get an error message?

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

M&M SSC-Insane Points: 21700 More actions · Answer 4

M&M

SSC-Insane

Points: 21700

August 17, 2011 at 10:38 am

#1369741

What is the error message?

M&M

sql_novice_2007 Hall of Fame Points: 3307 More actions · Answer 5

Its a named instance and got the following error.

Login failed for domain\username.(Microsoft Sql Server ,Error:18456).

The sql server is up and running and being used by others.

I was given admin privileges on the server, but when I try to connect to DB through SSMS I am getting the above error.

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 6

Have you checked the SQL Server error log?

http://msdn.microsoft.com/en-us/library/ms366351(v=sql.100).aspx

You may also try this troubleshooting tool.

http://blogs.msdn.com/sqlsecurity/archive/2010/03/29/sql-server-authentication-troubleshooter.aspx

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Lowell SSC Guru Points: 323518 More actions · Answer 7

sounds like security: remember in SQL 2008, or whenever installed on win7/server2003 and above, local admins on a box are no longer admins in SQL.

connect as sa, add your domain login , make sure you give yourself admin priviledges.

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!

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 8

You were told that you have permissions but I would verify.

Go to someone that you feel comfortable and verify what roles you are a member of, etc.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

SQLRNNR SSC Guru Points: 281334 More actions · Answer 9

I would also verify that there is only one instance on that server.

It is a named instance, are you connecting to like the following:

Servername\InstanceName

or just

Servername

?

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events