[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1046
  • Last Modified:

SQL server 2008 R2 version 10.50.1600.1 issue cannot get into new database

I have just installed a SQL 2008 and now cannot get into the database install that I just created .

I have made sure the SQL browser service is running ( It was disabled )


HELP!

thanks!
0
NAMEWITHELD12
Asked:
NAMEWITHELD12
  • 4
  • 2
1 Solution
 
Patrick BogersDatacenter platform engineer LindowsCommented:
How do you try to logon? Through the SQL Server management Studio?
If so, do you connect with    servername\databasename

Then how are you authenticating? Windows/SQL or mixed mode?

If connecting from remote, did you enable TCP/IP and configure the open port 1433 and allow remote connections?
0
 
NAMEWITHELD12Author Commented:
I have tried from management studio both mixed and windows mode

I am not remote I am right on the box

here is the error

error
thanks for the quick reply
0
 
NAMEWITHELD12Author Commented:
connect with    servername\databasename

LOL ha right on dude !!!!
0
Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

 
NAMEWITHELD12Author Commented:
AWESOME , love EE!!!

 connect with    servername\databasename
0
 
Patrick BogersDatacenter platform engineer LindowsCommented:
hehe love this kind of reactions... glad to got you working.
0
 
NAMEWITHELD12Author Commented:
Patrick , thanks again , I was sure thinking about it to much !!!
0

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now