Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2014-01-09
6
Medium Priority
?
1,033 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 23

Accepted Solution

by:
Patrick Bogers earned 2000 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
Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

 
LVL 1

Author Closing Comment

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

 connect with    servername\databasename
0
 
LVL 23

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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
After seeing many questions for JRNL_WRAP_ERROR for replication failure, I thought it would be useful to write this article.
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…
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…

783 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