Results 1 to 5 of 5

Thread: Can't Connect to Database created in SQL Server Management Studio 2014

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Dec 2015
    Location
    Hastings, UK
    Posts
    137

    Can't Connect to Database created in SQL Server Management Studio 2014

    I am completely new to VB and SQL server, although I have experience using MySQL.
    I have created a database using the above SQL Server and click on the test connection and it succeeded once and then could not connect to the server.
    The data source is: Microsoft SQL Server Database File (SqlClient). It asks for the name of the database file and the only one I can find is in my My Douments folder.
    When I try to connect I get this message:
    Name:  DB Error.JPG
Views: 269
Size:  28.8 KB
    However I tried renaming the file in SQLMS and it did not change the filename on the one in my documents.
    So where does SQLMS save the files to?
    Or am I completely wrong in my assumption that I am trying to connect to a file and if the database existed it would appear in the combo box list?
    Using the Server Configuration Manager I have set the server for remote connection and checked that the TCP/IP port is 1433 and TCP Dynamic port is cleared. However in the Protocols for SQLEXPRESS under TCP/IP there are 7 IP settings (IP1 to IP7). I have set all of them to port 1433 and cleared the Dynamic port entry.
    Is this correct? Since doing so I can't see a server anymore!

    Is there a definitive guide to setting up the server?

    Also, I have SQL Server 2008 installed. Naively I thought that the SQLMS was a tool that can be used to manage the server, but it appears to be a server in its own right.
    Should I uninstall the older version?

    Please can somebody help?
    Attached Images Attached Images  

  2. #2
    Administrator Steve R Jones's Avatar
    Join Date
    Apr 2012
    Location
    Largo, FL.
    Posts
    1,820

    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.

  3. #3

    Thread Starter
    Addicted Member
    Join Date
    Dec 2015
    Location
    Hastings, UK
    Posts
    137

    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:
    Name:  DB Error3.jpg
Views: 101
Size:  28.1 KB

    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.

  4. #4

    Thread Starter
    Addicted Member
    Join Date
    Dec 2015
    Location
    Hastings, UK
    Posts
    137

    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:
    Name:  DB Error4.JPG
Views: 98
Size:  26.8 KB
    If I now click on Tables nothing happens.
    Last edited by Rocky48; Dec 20th, 2015 at 10:03 AM.

  5. #5
    Fanatic Member
    Join Date
    Oct 1999
    Location
    England
    Posts
    982

    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.


    Things I do when I am bored: DotNetable

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width