trouble connecting to remote SQL server for authentication

[brian.newman]

I've got an app which provides data based on the user who is logged in.
So, I need the user data to be on the same db server as the other
data. I'm trying to do this using the membership API. I've set up the
tables and sprocs and so forth using the aspnet_regsql.e xe (though, for
some reason, I had to do it using windows authentication rather than
using a SQL server account). I've modified the web.config file as
follows

<?xml version="1.0" encoding="utf-8"?>

<configuratio n
xmlns="http://schemas.microso ft.com/.NetConfigurati on/v2.0">

<connectionStri ngs>

<add name="SLAR-con" connectionStrin g="Data
Source=mySQLser ver;Initial Catalog=SLAR;Us er
Id=mydomain\myu serid;Password= mypassword" />

</connectionStrin gs>

<system.web>

<roleManager enabled="true" />

<authenticati on mode="Forms" />

<membership>

<providers>

<add connectionStrin gName="SLAR-con"
applicationName ="SLAR" minRequiredPass wordLength="5"

minRequiredNona lphanumericChar acters="0"
name="Customize dProvider"

type="System.We b.Security.SqlM embershipProvid er" />

</providers>

</membership>

</system.web>

</configuration>

and I've tested the login and it seems to be working. However, when I
go into the database on the SQL server to look at the user I created,
the user authentication tables are all empty. The data isn't being
stored on the SQL server where I want it to be (I'm assuming it is
being stored in a SQL Server express database on the local machine).
How do I get the data to be stored in the remote SQL server?
--------------------------------------------------------------------------------

[Cowboy \(Gregory A. Beamer\)]

Check both databases and make sure it is not pointiong locally. As long as
machine name is correct, you should be on the other server.

NOTE: SQL Server 2005 requires SQL Browser on to connect remotely. You also
have to have proper transports set up, as some versions install without
TCP/IP or named pipes on.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com

*************** *************** *************** ****
Think outside of the box!
*************** *************** *************** ****
<br**********@w pafb.af.milwrot e in message
news:11******** *************@i 3g2000cwc.googl egroups.com...

I've got an app which provides data based on the user who is logged in.
So, I need the user data to be on the same db server as the other
data. I'm trying to do this using the membership API. I've set up the
tables and sprocs and so forth using the aspnet_regsql.e xe (though, for
some reason, I had to do it using windows authentication rather than
using a SQL server account). I've modified the web.config file as
follows

<?xml version="1.0" encoding="utf-8"?>

<configuratio n
xmlns="http://schemas.microso ft.com/.NetConfigurati on/v2.0">

<connectionStri ngs>

<add name="SLAR-con" connectionStrin g="Data
Source=mySQLser ver;Initial Catalog=SLAR;Us er
Id=mydomain\myu serid;Password= mypassword" />

</connectionStrin gs>

<system.web>

<roleManager enabled="true" />

<authenticati on mode="Forms" />

<membership>

<providers>

<add connectionStrin gName="SLAR-con"
applicationName ="SLAR" minRequiredPass wordLength="5"

minRequiredNona lphanumericChar acters="0"
name="Customize dProvider"

type="System.We b.Security.SqlM embershipProvid er" />

</providers>

</membership>

</system.web>

</configuration>

and I've tested the login and it seems to be working. However, when I
go into the database on the SQL server to look at the user I created,
the user authentication tables are all empty. The data isn't being
stored on the SQL server where I want it to be (I'm assuming it is
being stored in a SQL Server express database on the local machine).
How do I get the data to be stored in the remote SQL server?
--------------------------------------------------------------------------------

[brian.newman]

Cowboy (Gregory A. Beamer) wrote:

Check both databases and make sure it is not pointiong locally. As long as
machine name is correct, you should be on the other server.

NOTE: SQL Server 2005 requires SQL Browser on to connect remotely. You also
have to have proper transports set up, as some versions install without
TCP/IP or named pipes on.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com

*************** *************** *************** ****
Think outside of the box!
*************** *************** *************** ****
<br**********@w pafb.af.milwrot e in message
news:11******** *************@i 3g2000cwc.googl egroups.com...

I've got an app which provides data based on the user who is logged in.
So, I need the user data to be on the same db server as the other
data. I'm trying to do this using the membership API. I've set up the
tables and sprocs and so forth using the aspnet_regsql.e xe (though, for
some reason, I had to do it using windows authentication rather than
using a SQL server account). I've modified the web.config file as
follows

<?xml version="1.0" encoding="utf-8"?>

<configuratio n
xmlns="http://schemas.microso ft.com/.NetConfigurati on/v2.0">

<connectionStri ngs>

<add name="SLAR-con" connectionStrin g="Data
Source=mySQLser ver;Initial Catalog=SLAR;Us er
Id=mydomain\myu serid;Password= mypassword" />

</connectionStrin gs>

<system.web>

<roleManager enabled="true" />

<authenticati on mode="Forms" />

<membership>

<providers>

<add connectionStrin gName="SLAR-con"
applicationName ="SLAR" minRequiredPass wordLength="5"

minRequiredNona lphanumericChar acters="0"
name="Customize dProvider"

type="System.We b.Security.SqlM embershipProvid er" />

</providers>

</membership>

</system.web>

</configuration>

and I've tested the login and it seems to be working. However, when I
go into the database on the SQL server to look at the user I created,
the user authentication tables are all empty. The data isn't being
stored on the SQL server where I want it to be (I'm assuming it is
being stored in a SQL Server express database on the local machine).
How do I get the data to be stored in the remote SQL server?
--------------------------------------------------------------------------------

It is being stored locally (local to the machine on which I'm doing the
development), but I'm unclear on how to point it to the SQL server db.
I thought the edits shown in the top post I made to the web.config file
would handle that, but they don't. The SQL server db is SQL Server
2000.
By the way, thanks for the assist. I posted on Microsoft asp.net forum
and got 20 views, but no assist and got nothing from 4guysfromrolla.