Hopefully Simple Fix (1 Viewer)

GBalcom · Oct 8, 2014

Ok, I installed SSMS 2014 and SQL Express 2014 to our server so I could begin to understand how to connect to it with access. Ultimately, my database will be hosted in the cloud through a service (Azure or similar).

Right now, Although I can connect to the database when I'm on the server, I cannot connect to it when I'm at my desktop through access. I installed SSMS on my computer and I cannot connect to it from there as well. It keeps saying the attached message...

I know I'm missing something simple in SSMS to set this up, but I don't know where to look? I'm a complete Newbie at SSMS. I've just purchased a book on this (won't be here for a few days) and I was hoping someone had the answer before I get it.

Thanks!:banghead:

Minty · Oct 8, 2014

Have you set permissions on the database to allow users to connect?

GBalcom · Oct 8, 2014

Hello Minty,
Yes, I believe I have...In fact, I have another server instance that I can log into just fine, and my computer "Atantacabinet\Gary" has more permissions in the one that doesn't work....I'm very confused.

I created a video of the settings, and will attempt to attach. they are in .swf format, which I created with Jing (free) from techsmith.

The uploaded video format was not valid to upload to this website. I've wrapped it in a .zip folder.

Thanks for any and all help!!!

Minty · Oct 8, 2014

Sorry I'm having trouble opening that Video.
SSMS is pretty straight forward, Are you set up as a user on the new server instance?
It won't inherit you as a user from the other database.

GBalcom · Oct 8, 2014

yes I am....I was using windows authentication

GBalcom · Oct 8, 2014

Here, I've reposted this as a link on screencast.com

You should be able to just follow the link

http://screencast.com/t "Slash" ziicboncK58z

Thanks!

Minty · Oct 8, 2014

Okay - Have you checked you have allowed remote connections?
Right click the top level database container (SERVER\ACSCABINETS) select properties and then open the connections properties.

There is a remote server connections box that will need ticking

GBalcom · Oct 8, 2014

Ok, it is checked, but the remote query timeout is set to 600? What should it be?

Also, I can't seem to find where the actual .mdf and .ldf files are being stored..Is there a way to tell within the gui?

GBalcom · Oct 8, 2014

I think I'm on to something...

If I go to the "SQL SERVER Configuration manager",
Then SQL Server Services, the SQL SERVER Browser AND the SQL SERVER Agent are stopped.

Both had a "start mode" property of disabled. I put them to automatic, and was able to start the SQL Server Browser.

When I try to restart the SQL Server Agent, I get the attached error

GBalcom · Oct 8, 2014

OK I GOT IT ;-)

It was the within the SQL Server Configuration Manager

Under SQL Server Network Configuration, the TCP/IP was Disabled for the database.....

Thanks for your help!

GBalcom · Oct 8, 2014

I'll also note for anyone in the future, that I found this link very helpful in the troubleshooting:

http://social.technet.microsoft.com...ecting-to-the-sql-server-database-engine.aspx

Hopefully Simple Fix (1 Viewer)

GBalcom

Much to learn!

Attachments

Minty

AWF VIP

GBalcom

Much to learn!

Attachments

Minty

AWF VIP

GBalcom

Much to learn!

GBalcom

Much to learn!

Minty

AWF VIP

GBalcom

Much to learn!

GBalcom

Much to learn!

Attachments

GBalcom

Much to learn!

GBalcom

Much to learn!

Similar threads

Users who are viewing this thread