Solved

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

Posted on 2014-01-09
6
989 Views
Last Modified: 2014-01-09
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
Comment
Question by:NAMEWITHELD12
  • 4
  • 2
6 Comments
 
LVL 20

Accepted Solution

by:
Patrick Bogers earned 500 total points
ID: 39769269
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
 
LVL 1

Author Comment

by:NAMEWITHELD12
ID: 39769278
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
 
LVL 1

Author Comment

by:NAMEWITHELD12
ID: 39769286
connect with    servername\databasename

LOL ha right on dude !!!!
0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
LVL 1

Author Closing Comment

by:NAMEWITHELD12
ID: 39769289
AWESOME , love EE!!!

 connect with    servername\databasename
0
 
LVL 20

Expert Comment

by:Patrick Bogers
ID: 39769301
hehe love this kind of reactions... glad to got you working.
0
 
LVL 1

Author Comment

by:NAMEWITHELD12
ID: 39769316
Patrick , thanks again , I was sure thinking about it to much !!!
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
A procedure for exporting installed hotfix details of remote computers using powershell
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question