Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact us.

Post New Thread Reply

Register GFY Rules Calendar
Go Back   GoFuckYourself.com - Adult Webmaster Forum > >
Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed.

 
Thread Tools
Old 07-28-2017, 01:31 PM   #1
astronaut x
Too lazy to set a custom title
 
astronaut x's Avatar
 
Industry Role:
Join Date: May 2011
Location: From this www and beyond!
Posts: 4,844
Question for ASP.NET gurus....

So I am trying to connect a website to an SQL server database on the machine that is hosting the website.

I have managed to make the connection from my local application to a copy of the database also on my local machine.

I would assume, that when I deploy the web app to their server, that I just change the connection string in the web.config file. They supplied me with DSN, UID, and PWD variables but it seems to me I need more than that, or do I need something totalyl different?

Windows Server 2008 R2
SQL server 2008

What do I need to come up with the correct connection string?
astronaut x is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 07-28-2017, 02:30 PM   #2
Ferus
Bye - Left to do stuff
 
Industry Role:
Join Date: Feb 2013
Posts: 4,109
Should look like this. If it dont work, look at the eventlog on the SQL server, if you get a deny event, because your premissions is not set right


Code:
<connectionStrings>
    <add name="DefaultConnection" connectionString="Data Source=SERVERNAME\sqlINSTANCE;Initial Catalog=Databasename;User ID=sa;Password=sa" />
  </connectionStrings>
Ferus is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 07-28-2017, 04:41 PM   #3
astronaut x
Too lazy to set a custom title
 
astronaut x's Avatar
 
Industry Role:
Join Date: May 2011
Location: From this www and beyond!
Posts: 4,844
Quote:
Originally Posted by Ferus View Post
Should look like this. If it dont work, look at the eventlog on the SQL server, if you get a deny event, because your premissions is not set right


Code:
<connectionStrings>
    <add name="DefaultConnection" connectionString="Data Source=SERVERNAME\sqlINSTANCE;Initial Catalog=Databasename;User ID=sa;Password=sa" />
  </connectionStrings>

Is it possible it could be any of these other options?

https://www.connectionstrings.com/sql-server-2008/
astronaut x is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Post New Thread Reply
Go Back   GoFuckYourself.com - Adult Webmaster Forum > >

Bookmarks

Tags
server, connection, machine, local, database, string, website, sql, variables, supplied, dsn, file, uid, pwd, correct, windows, web.config, totalyl, deploy, hosting, managed, connect, asp.net, gurus, application



Advertising inquiries - marketing at gfy dot com

Contact Admin - Advertise - GFY Rules - Top

©2000-, AI Media Network Inc



Powered by vBulletin
Copyright © 2000- Jelsoft Enterprises Limited.