Solved

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

Posted on 2014-01-09
6
993 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
Technology Partners: 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…

734 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