setting up ith IIS - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

setting up ith IIS

Author

Topic

jarv
Posting Yak Master

131 Posts

Posted - 2007-07-30 : 18:12:55

How do i do it? do i have to set up an ODBC?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-07-30 : 18:28:40

You do not need to use ODBC to connect from a web site to SQL Server. In fact, you shouldn't. ODBC is so old. Are you familiar with ADO.NET and connection strings? If not, you need to get a book that deals with this.

Tara Kizer
http://weblogs.sqlteam.com/tarad/

jarv
Posting Yak Master

131 Posts

Posted - 2007-07-31 : 05:41:49

can someone please help, I have visual studio and ODBC and they sometimes connect I don't knwo how to test my site with MSSQL server??! please help!

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-07-31 : 06:03:56

www.connectionstrings.com

Or this which I find better
http://www.carlprothman.net/Default.aspx?tabid=81

E 12°55'05.25"
N 56°04'39.16"

jarv
Posting Yak Master

131 Posts

Posted - 2007-07-31 : 10:08:50

thanks, i have a SQL connection string:

Data Source=localhost\SQLEXPRESS;Initial Catalog=john

and the error i get is: Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/pubspace/includes/functionlib.asp, line 13

and when i use my other connection:

driver={SQL Server};server=mute\SQLEXPRESS;uid=John;pwd=j0hn;database=john

I get the error:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not found.
/pubspace/includes/functionlib.asp, line 13

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-07-31 : 10:15:33

Provider=sqloledb;Data Source=localhost\SQLEXPRESS;Initial Catalog=john;User Id=<myUsername>;Password=<myPassword>

E 12°55'05.25"
N 56°04'39.16"

jarv
Posting Yak Master

131 Posts

Posted - 2007-07-31 : 10:22:45

i don't think i have ausername and password?!

jarv
Posting Yak Master

131 Posts

Posted - 2007-07-31 : 10:24:52

i tried:

Provider=sqloledb;Data Source=localhost\SQLEXPRESS;Initial Catalog=john;User Id=John;

and now i get:[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
/pubspace/includes/functionlib.asp, line 13

jarv
Posting Yak Master

131 Posts

Posted - 2007-07-31 : 10:28:24

don't i have to setup a system ODBC?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-07-31 : 10:33:35

No, not with OLEDB.

E 12°55'05.25"
N 56°04'39.16"

jarv
Posting Yak Master

131 Posts

Posted - 2007-07-31 : 10:36:59

where do i setup my username an dpassword? i can't even login to my database now via windows login

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-07-31 : 10:40:15

You need a SQL server account.

Or (if you have read the links I posted earlier)
Provider=sqloledbData Source=localhost\sqlexpress;Initial Catalog=john;Integrated Security=SSPI

but then you have to set up IIS to incorporate integrated security.

E 12°55'05.25"
N 56°04'39.16"

jarv
Posting Yak Master

131 Posts

Posted - 2007-07-31 : 10:40:33

MSSQL server is running local can't connect to it?! hmm uid and pwd??

jarv
Posting Yak Master

131 Posts

Posted - 2007-07-31 : 10:46:40

i just added Integrated Security=SSPI on teh end of my connection string, still says: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

I have IIS running!how would i setup a SQL server account if i needed to?

jarv
Posting Yak Master

131 Posts

Posted - 2007-07-31 : 12:00:08

i have just switched back to my ACCESS DATABASE and i cannot login anymore I am using the correct UserName and Password taht are in my database!

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-07-31 : 12:09:01

Since you are getting SQL Server does not exist or access denied error, you've got some configuration issue as that's a message that indicates network issues, the service is stopped, or various other connection-related problems. Check to make sure that the SQL Server service is running. Based upon the error, you are running SQL Server 2000, so the service will be named MSSQLSERVER if you installed the default instance or MSSQL$InstanceName if you installed a named instance. Make sure it says Started and Automatic.

Tara Kizer
http://weblogs.sqlteam.com/tarad/

jarv
Posting Yak Master

131 Posts

Posted - 2007-07-31 : 12:18:01

it was running, i just restarted it

in Client Protocols: should i have
Shared memory = 1
TCP/IP = 2
NamedPipes = 3
VIA = Disabled ?

jarv
Posting Yak Master

131 Posts

Posted - 2007-07-31 : 12:19:10

and should i restart IIS?

jarv
Posting Yak Master

131 Posts

Posted - 2007-07-31 : 12:49:12

ok I reinstalled the SQL EXPRESS MANAGEMENT and now i can connect to the console and create a database!

I have teh connection string:

Provider=sqloledb;Data Source=localhost\SQLEXP;uid=john;pwd=j0hn

and get the error: Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
/pubspace/includes/functionlib.asp, line 13

karuna
Aged Yak Warrior

582 Posts

Posted - 2007-07-31 : 13:11:30

quote:
Originally posted by jarv

I have teh connection string:
Provider=sqloledb;Data Source=localhost\SQLEXP;uid=john;pwd=j0hn

and get the error: Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
/pubspace/includes/functionlib.asp, line 13

Try

Provider=sqloledb;Data Source=.\SQLEXP;uid=john;pwd=j0hn

Thanks
Karunakaran

jarv
Posting Yak Master

131 Posts

Posted - 2007-07-31 : 13:20:00

i've done it! thanks very much for all your help, now i hav eto convert databases?!

Previous Page&nsp; Next Page

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources