-
Dec 18th, 2015, 07:18 AM
#1
Thread Starter
Addicted Member
-
Dec 18th, 2015, 08:19 AM
#2
Re: Can't Connect to Database created in SQL Server Management Studio 2014
SQL would normally place the db in a folder similar to:
C:\Program Files\Microsoft SQL Server\MSSQL\Data
And the "Authentication" in the second screenshot would normally be set to SQL Server.
Wi-fi went down for five minutes, so I had to talk to my family....They seem like nice people.
-
Dec 18th, 2015, 01:01 PM
#3
Thread Starter
Addicted Member
Re: Can't Connect to Database created in SQL Server Management Studio 2014
Thank you for indicating where the files are stored!
I remember in the setup choosing windows Authentication, so that's why I used that.
I tried to connect using SQL Server Management Studio 2014, but now I get the following Error:
Still can't connect to any server!
In VB Studio tried again to connect to a database, but now says the file is in use? But nothing else running?
Can anyone help please!
Last edited by Rocky48; Dec 20th, 2015 at 10:04 AM.
-
Dec 18th, 2015, 01:35 PM
#4
Thread Starter
Addicted Member
Re: Can't Connect to Database created in SQL Server Management Studio 2014
Right I am really getting confused!!
I have gone back to VB Studio and had forgotten the procedure that was given in the book I am learning from regarding setting up a database.
I added a new Item (Service-based Database) and it now shows a database in the in the database explorer.
I am not sure what version the book is using, but when I right click on tables it is supposed to display Add New Table in the context menu, but all it shows is Refresh and Properties, and the following error is displayed when I disconnect and re-connect:
If I now click on Tables nothing happens.
Last edited by Rocky48; Dec 20th, 2015 at 10:03 AM.
-
Dec 29th, 2015, 06:47 AM
#5
Fanatic Member
Re: Can't Connect to Database created in SQL Server Management Studio 2014
SSMS (SQL Server Management Studio) is a client application for connecting to MSSQL, it is not a server.
SSMS is backward compatible so you can connect to earlier versions of SQL server (including SQLExpress). So from SSMS 2014 you can connect to SQL 2005 and later.
I searched google for
Could not load file or assembly Microsoft.SqlServer.management.sdk.sfc
and found this thread on stackoverflow
http://stackoverflow.com/questions/1...-sfc-version-1
it is worth checking out, and bookmarking.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|