accessing data base from remote computer

we have sql 2005 standard edition. i was trying ( unsuccessfully ) to configure RAS on server 2003 to allow the server to authentificate vpn requests. i don't know how but the next day people started complaining about their mapped network drives being disconnected, and now no one can connect to the database via the network, eventhough they still have access to the server, and the network drives were remapped.

Any errors or information in event log for such behaviour?

http://www.microsoft.com/technet/community/chats/trans/windowsnet/win0608.mspx & http://www.tacteam.net/isaserverorg/vpnkitbeta2/vpnclientbrowsing.htm fyi.

I believe this is more based on Windows side question than to SQL Server related.

|||actually now that you mention it, there is a message that keeps showing up since about the time i started playing around with RAS. it is from NfsSvr. it says mapping information could not be obtained from user mapping. another attempt will be made in 30 minutes. this message first appeared about noon on fri. however we started having trouble late thur. the message repeats itself every 30 minutes.

accessing data base from remote computer

we have sql 2005 standard edition. i was trying ( unsuccessfully ) to configure RAS on server 2003 to allow the server to authentificate vpn requests. i don't know how but the next day people started complaining about their mapped network drives being disconnected, and now no one can connect to the database via the network, eventhough they still have access to the server, and the network drives were remapped.

Any errors or information in event log for such behaviour?

http://www.microsoft.com/technet/community/chats/trans/windowsnet/win0608.mspx & http://www.tacteam.net/isaserverorg/vpnkitbeta2/vpnclientbrowsing.htm fyi.

I believe this is more based on Windows side question than to SQL Server related.

|||actually now that you mention it, there is a message that keeps showing up since about the time i started playing around with RAS. it is from NfsSvr. it says mapping information could not be obtained from user mapping. another attempt will be made in 30 minutes. this message first appeared about noon on fri. however we started having trouble late thur. the message repeats itself every 30 minutes.

Accessing AdventureWorks DB from ASPNET

Hi folks,

I've been wondering whats the "appropriate" way to configure AdventureWorks DB such that the WHOLE database can be access from Visual Studio and ASPNET webpages.

The problem I keep beating my head against is the schema problem which prevents me from accessing tables with different schema.

What I've done/can do so far is:

1. Installed AdventureWorks DB
2. Can run SQL cmds from Winforms apps and these are working as expected.
3. I've added MACHINENAME\ASPNET to the database. The default schema is "dbo".
4. The DB is running on the same server as the web server.
When I try to execute something trivial such as:

SqlConnection connection = new SqlConnection("Data Source=localhost;Initial Catalog=AdventureWorks;Integrated Security=true;");

try

{

connection.Open();

SqlCommand command = new SqlCommand("SELECT * FROM [Production.Product]", connection);

SqlDataReader reader = command.ExecuteReader();
...
To get the above to work I need to set the ASPNET users schema to Production.

I will admit I am a novice when it comes to SQL Server but I'm learning fast.

Can anyone help?

Short of trawling through a ton of code what was Microsofts intended usage of schema and how would one access tables located in multiple schemas from ASPNET.

Thanks,

Philip.

See the response at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=166975&SiteID=1

Access Denied when setting up a Subscriber for replication

i verified that the server settings and authentication is
the same for both servers/
i am trying to configure a windows 2003 server running sql
server 2000 to be a subscriber to a publisher runnign
win2k and sql 2000.
when I try to register the server, i get access denied.
any thoughts?
thanks
Jeff,
can you test network connectivity using PING and NET VIEW
(http://www.microsoft.com/resources/d...2003/standard/
proddocs/en-us/Default.asp?url=/resources/documentation/WindowsServ/2003/sta
ndard/proddocs/en-us/sag_TCPIP_pro_PingConnect.asp).
Can you also use QA on hte subscriber and test this tool, using a SQL user
(assuming mixed mode authentication).
Can you check that the SQL Server Service is started on the publisher
(sounds obvious but it's better if I ask).
Regards,
Paul Ibison
|||Hi Paul,
i can connect to the server using QA and specifying the IP
of the server. I can also ping using host name and IP.
thanjks

>--Original Message--
>Jeff,
>can you test network connectivity using PING and NET VIEW
>
(http://www.microsoft.com/resources/d...tion/WindowsSe
rv/2003/standard/
>proddocs/en-us/Default.asp?
url=/resources/documentation/WindowsServ/2003/sta
>ndard/proddocs/en-us/sag_TCPIP_pro_PingConnect.asp).
>Can you also use QA on hte subscriber and test this tool,
using a SQL user
>(assuming mixed mode authentication).
>Can you check that the SQL Server Service is started on
the publisher
>(sounds obvious but it's better if I ask).
>Regards,
>Paul Ibison
>
>.
>
|||Jeff,
can you connect using QA and the host name with trusted / non-trusted
security (logging into windows using the same account as the sql server
agent).
If you can connect using trusted security and host name then check that the
Account is in the PAL for the publication.
Finally, I did read in a thread that DTC needs enabling, which it isn't by
default in Win 2003
(http://support.microsoft.com/default...5bLN%5d;817064). I
understand the need for DTC in immediate updating subscribers but haven't
testes whether this thread was correct or not. Anyway, if it's not enabled
and the above comments don't lead to the solution, please try this also.
HTH,
Paul Ibison
|||I'd check your Client Network Utility Settings and verify that they are
pointing to the correct server.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:u1BBBRLaEHA.4092@.TK2MSFTNGP11.phx.gbl...
> Jeff,
> can you connect using QA and the host name with trusted / non-trusted
> security (logging into windows using the same account as the sql server
> agent).
> If you can connect using trusted security and host name then check that
the
> Account is in the PAL for the publication.
> Finally, I did read in a thread that DTC needs enabling, which it isn't by
> default in Win 2003
> (http://support.microsoft.com/default...5bLN%5d;817064). I
> understand the need for DTC in immediate updating subscribers but haven't
> testes whether this thread was correct or not. Anyway, if it's not enabled
> and the above comments don't lead to the solution, please try this also.
> HTH,
> Paul Ibison
>
|||Hilary and Paul,
i have looked at the client network util. and verified
they are pointing to the right server.
The issue now is, I cannot even register the server from
the Publisher in the ACL list. This is getting weirder by
the minute. I can verify connectivity by ping with no
issues.
In the Client util, i configure the server name on the
alias and the IP and also specify the port the SQL server
is listening on at the Subscriber. So at this point, i am
not sure what the issue is...
thanks for your help

>--Original Message--
>I'd check your Client Network Utility Settings and verify
that they are[vbcol=seagreen]
>pointing to the correct server.
>--
>Hilary Cotter
>Looking for a book on SQL Server replication?
>http://www.nwsu.com/0974973602.html
>
>"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
>news:u1BBBRLaEHA.4092@.TK2MSFTNGP11.phx.gbl...
trusted / non-trusted[vbcol=seagreen]
as the sql server[vbcol=seagreen]
then check that[vbcol=seagreen]
>the
enabling, which it isn't by[vbcol=seagreen]
5bLN%5d;817064). I[vbcol=seagreen]
subscribers but haven't[vbcol=seagreen]
if it's not enabled[vbcol=seagreen]
please try this also.
>
>.
>