administering SQL to get a connection string working

[mmarkym]

I have a couple questions here.
I've set up SQL 7 on my machine along with IIS.
I have websites on IIS. They open fine on my machine but when somebody else tries to open from a remote machine they get "page cannot be displayed" Is this do to not having configured IIS to let remote machines access the server? If so how would I do this?

Also I'm trying to set a connection string to SQL server from an asp page.

I have
strConnectionString = "Provider=sqloledb;" & _
"Data Source=localserver;" & _
"Initial Catalog=myDatabase;" & _
"User Id=mark;" & _
"Password=sa"
I'm having trouble with the username and password. How do I find sql server username and password as well as the database login. I've tried to open properties on each and changing the inputs but I,m getting different error messages. Server does not exist or access denied, Acess denied for username (myUsername).

 

[TheBugSlayer]

I am not a web expert but the 'Page cannot be displayed' may have to do with name resolution through DNS. Try using the IP address in IE. If it works then the name of your site is not 'understood' by the other machine; talk a net admin then.

In SQL EM go to security and look in Logins. You will see user names but the passwords are encrypted.

Is LocalServer a variable or are you trying to use the local Server (local)?

Make sure the users you are connecting as have the proper rights on the DB, starting with the access.