Solved

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

Posted on 2014-01-09
6
1,000 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 23

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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

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

A procedure for exporting installed hotfix details of remote computers using powershell
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…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

630 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