By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,266 Members | 1,297 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,266 IT Pros & Developers. It's quick & easy.

no access to new instance of sql server

100+
P: 143
I just recently installed a new instance of sql server 2005 on the second hard drive on my machine. It installed flawlessly and all the services are started. I don't have sql server management studio on my server with the databases so I configured the new instance to allow remote connections. When I go to my regular machine and try to access through remote connection and management studio, the new instance of sql server will not recognize the credentials I gave it.

How do I gain remote access to my database? Do I create a new user from the host box using a configuration tool? If so, how?

Thanks for any help anyone can give.
Jun 11 '09 #1
Share this Question
Share on Google+
5 Replies


ck9663
Expert 2.5K+
P: 2,878
What credential are you using? Did you configure it to handle mix authentication or sql account only?


--- CK
Jun 11 '09 #2

100+
P: 143
I configured for mix, but I (being a fairly new developer and no network experience) don't have my network fully configured yet. SQL Server won't recognize windows authentication yet.

This setup works great for me on the default instance.

So, long answer short......sql account only.
Jun 11 '09 #3

ck9663
Expert 2.5K+
P: 2,878
Are you using admin or sa?


--- CK
Jun 11 '09 #4

100+
P: 143
when I set up the instance, I used administration and administration. The plan was to change the credentials through remote access once connection was made.
Jun 11 '09 #5

ck9663
Expert 2.5K+
P: 2,878
I'm not sure how your network look like. If you can, try installing the Enterprise Manager on your server as well.

--- CK
Jun 12 '09 #6

Post your reply

Sign in to post your reply or Sign up for a free account.