Welcome to the Inedo Forums! Check out the Forums Guide for help getting started.
If you are experiencing any issues with the forum software, please visit the Contact Form on our website and let us know!
How do I connect to a remote SQL instance, using IIS with Proget
-
Hello,
I am having difficulty to access proget page when changing connection string to connect to a remote SQL server we have.
When using " Data Source=MSR-TG-PKG01\ProGet; Initial Catalog=ProGet; Integrated Security=SSPI " , which is the default setting, I have no issues, the proget server works fine.
When I try "Server=[Server name];Database=[DB name];User ID=[Username];Password=[Password]"
I get following error : [SqlException (0x80131904): Cannot open database "tg_proget" requested by the login. The login failed.
Login failed for user 'sql_tg_proget'.]
Cannot open database "tg_proget" requested by the login. The login failed.
Login failed for user 'sql_tg_proget'.The login works fine, I have tested it through SQL Server 2014 and can login to the database so the issue is not there.
I am suspecting either I'm missing a configuration within IIS or within Proget.
Thanks for your help!
Product: ProGet
Version: 4.3.1 -
That error message is coming directly from your remote SQL Server, and it can mean several different things:
- wrong password is specified for
sql_tg_progeton that server - the
tg_progetdatabase does not exist on that server - the
sql_tg_progetuser does not have access totg_progeton that server - SQL Authentication is disabled on that server, or another setting is preventing the application from logging in to the database using that name/password; for security purposes, SQL Server does not log these reasons to the client
In this situation, your connection string needs to be modified to either point to the correct server, and/or use the correct username, password, and database, or the sql server needs to be configured to permit that connection string.
There is no other configuration required (or even possible) on the application side to connect to the database. Only the connection string.
- wrong password is specified for
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login