Re: Can my ASP.NET dev workstation see remote SQL server?

From: Timo (timo_at_anonymous.com)
Date: 03/11/04 

Date: Thu, 11 Mar 2004 12:41:32 -0500

Thanks for responding. But I don't know what is meant by "register the
server". Is that something I do with Visual Studio.NET? Do I need a special
"enterprise" level of VS.NET for that?
Timo

"Cowboy (Gregory A. Beamer)" <NoSpamMgbworld@comcast.netNoSpamM> wrote in
message news:u2P1gd4BEHA.2380@TK2MSFTNGP10.phx.gbl...
> You should be able to register the server using the format domain\username
> and then develop against it. NOTE that, by default, the method of security
> is windows and not mixed, but that sounds fine in your case.
>
> --
> Gregory A. Beamer
> MVP; MCP: +I, SE, SD, DBA
>
> "Timo" <timo@anonymous.com> wrote in message
> news:uPs3ZS4BEHA.624@TK2MSFTNGP10.phx.gbl...
> > I would like to develop my ASP.NET application against a SQL 2000
database
> > residing on another server, rather than against the SQL server installed
> > locally. We're using Windows integrated security. When I'm using
Visual
> > Studio the ASP.NET user belongs to my XP machine's local domain, which
is
> > not recognized by the remote SQL server as belong to its domain. It is
> > possible to set up the SQL Server, my local XP machine, or my web.config
> > file so that when I develop an app in Visual Studio (Debug -> Start), I
> can
> > access the remote SQL database?

Relevant Pages

  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
  • RE: migrating from wmsde to sql server
    ... Click Start, point to All Programs\Microsoft SQL Server, and then click ... then click New SQL Server Registration. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • Re: Clickonce and license question question
    ... updates the SQL server at our ISP that the license key is now in use. ... They are unable to register the application and they get an SQL error. ...
    (microsoft.public.dotnet.framework.windowsforms)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
  • Re: Best replication architecture?
    ... Looking for a SQL Server replication book? ... So if it is subscribing to Publisher 1, ...
    (microsoft.public.sqlserver.replication)