Help -I am trying to create a local database on my PC. Why is it failing

Question

Help -I am trying to create a local database on my PC. Why is it failing

mw_sql_developer

SSCoach

Points: 19445
More actions
January 25, 2016 at 11:00 am

#399621

Please see attached.
The highlighted field represents my PC name.
All this time I have been connecting to other servers. This time I thought I will have something locally on my PC
Please help me on how I can create a database locally on my PC

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

pietlinden SSC Guru Points: 63503 More actions · Answer 1

If you're trying to create a database on your local machine, then when you log into SQL Server, the instance should be something like YOUR_MACHINE_NAME\INSTANCE_NAME. Can you log in like that?

Perry Whittle SSC Guru Points: 234013 More actions · Answer 2

mw112009 (1/25/2016)
Please see attached.
The highlighted field represents my PC name.
All this time I have been connecting to other servers. This time I thought I will have something locally on my PC
Please help me on how I can create a database locally on my PC

You have a login failure for the user account you're using.

Which accounts did you grant access to during the installation?

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

mw_sql_developer SSCoach Points: 19445 More actions · Answer 3

mw_sql_developer

SSCoach

Points: 19445

January 25, 2016 at 11:59 am

#1854262

I did not install SSMS. Someone else did

mw_sql_developer SSCoach Points: 19445 More actions · Answer 4

Reply to "pietlinden"

How do I find the instance name ?

kreuzer Ten Centuries Points: 1246 More actions · Answer 5

Hi,

if you have no access do SSMS, you can try this command in powershell:

SQLCMD -L

You should get a list of sql-server with instance name.

Hope you've the right to execute.

Kind regards,

Andreas

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 6

mw112009 (1/25/2016)
Please see attached.
The highlighted field represents my PC name.
All this time I have been connecting to other servers. This time I thought I will have something locally on my PC
Please help me on how I can create a database locally on my PC

Do you have an instance of SQL Server running on your local PC? If you aren't sure exactly what this means, then the answer is probably "No".

You could create a database on your local PC if the instance (server) that you usually connect to can "see" your PC and shared drives, but I don't think this is what you mean when you say "create a database locally".

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden