July 14, 2008 at 9:10 am
Hi, I'm having trouble creating a new login account to access my DB. I prefer to use Windows Authentication over SQL Server Authentication, but I don't mind either way. The problem I'm facing is that when I try to create a new account from MSSMSE, beside login name, if I choose search, I only see the location of the local computer, and not the one I will be logging in from. How do I add another computer into this dialogue?
Another issue, I did manage to get SQL Server Authentication working, but everytime a query is executed from the remote location, it prompts for name and password. Any suggestions?
I'm VERY new (first tme) to SQL Server, so this is all very foreign to me, so far, everything is smooth, but this is my last hurdle.
many thanks,
Luke
July 14, 2008 at 9:30 am
SQL Server should prompt for name and password with SQL Auth unless you have them saved. That's the way it goes. You can pass them in with the connection string from your application.
You don't add a computer into the dialogue. The only thing you need from any computer is the target server you're connecting to, not the client you are connecting from.
July 14, 2008 at 9:35 am
Hi Luke,
There should be a button labeled "Locations..." next to the local computer name after clicking "Search...". If you click "Locations...", you'll be able to see other computers in the network.
As for SQL Server authentication, I believe most applications provide login and password in a connection string so SQL Server won't prompt for it. I'm not a developer, so I can't offer an example.
Greg
July 14, 2008 at 9:36 am
Steve Jones - Editor (7/14/2008)
You can pass them in with the connection string from your application.
How would I go about doing this? What I've done so far is create a DB in Access 2007 with forms, reports and queries, then upsized the back end to SQL Server 2005.
thanks
July 14, 2008 at 9:43 am
[quoteThere should be a button labeled "Locations..." next to the local computer name after clicking "Search...". If you click "Locations...", you'll be able to see other computers in the network./quote]
Thanks Greg, that's my problem (okay, probably not a problem, more like lack of experience), when I click search, all I see is the local computer. I would imagine if the remote computer name showed up, I could simply select a user associated with that computer.
On a side note, all firelwalls are disabled at this point to ensure they're not interfering.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply