Connnecting to an MS Access DB with an MS SQL 2000 Stored Proc

I would like to access a table in MS Access from a stored procedure on MS
SQL 2000. The MS Access DB is running on a diferent computer attached on the
same network. I think I need to create an ODBC connection from the MS SQL
2000 to the MS Access DB but not sure. Secondly how do I refer to the table
in the MS SQL stored proc?

Thanks for your input,

Joe SeamourYou need to add a linked server, and then you can query the Access database
directly. The BOL entry for sp_addlinkedserver shows an example, and the
topic "OLE DB Provider for Jet" has more details.

I've never set this up to use an Access DB on a different server myself, but
I think it should work if the MSSQL service account has permission to access
the share where the .mdb file is.

When the linked server is configured, you can query it like this.

SELECT * FROM MyLinkedServer...Table

Simon

"Joe Seamour" <jseamour@.attbi.com> wrote in message
news:1MYKa.33514$Bg.16441@.rwcrnsc54...
> I would like to access a table in MS Access from a stored procedure on MS
> SQL 2000. The MS Access DB is running on a diferent computer attached on
the
> same network. I think I need to create an ODBC connection from the MS SQL
> 2000 to the MS Access DB but not sure. Secondly how do I refer to the
table
> in the MS SQL stored proc?
> Thanks for your input,
> Joe Seamour

Connectivty problem from NON domain users

I have a problem esteblishing a connection to a SQL server with a SQL user,
while I am logged to the computer with a local computer.
Any domain account can has no problem.
What can ause this?
Thanks in advance,
Ido Friedman
What tool are you connecting from?
How are you trying to connect?
Do you know for sure that you are trying to connect via SQL Authentication?
Have you tried hitting the Data Sources (ODBC) applet within the Control
Panel and creating a test connection?
Keith Kratochvil
"Ido friedman" <Idofriedman@.discussions.microsoft.com> wrote in message
news:934F22F5-2624-49B2-AC35-1970C1AE876D@.microsoft.com...
>I have a problem esteblishing a connection to a SQL server with a SQL user,
> while I am logged to the computer with a local computer.
> Any domain account can has no problem.
> What can ause this?
> Thanks in advance,
> Ido Friedman
|||Do you have mixed mode authentication enabled?
To enable...
SQL 2005
In SQL Server Management Studio Object Explorer, right-click your server,
and then click Properties.
On the Security page, under Server authentication, select the new server
authentication mode, and then click OK.
In the SQL Server Management Studio dialog box, click OK, to acknowledge the
need to restart SQL Server.
SQL 2000
Expand a server group.
Right-click a server, and then click Properties.
Click the Security tab.
Under Authentication, click SQL Server and Windows.
Under Audit level, select the level at which user accesses to Microsoft SQL
ServerT are recorded in the SQL Server error log:
None causes no auditing to be performed.
Success causes only successful login attempts to be audited.
Failure causes only failed login attempts to be audited.
All causes successful and failed login attempts to be audited.
Hope that helps...
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/
"Ido friedman" <Idofriedman@.discussions.microsoft.com> wrote in message
news:934F22F5-2624-49B2-AC35-1970C1AE876D@.microsoft.com...
>I have a problem esteblishing a connection to a SQL server with a SQL user,
> while I am logged to the computer with a local computer.
> Any domain account can has no problem.
> What can ause this?
> Thanks in advance,
> Ido Friedman
|||Thanks for your reply,
I am using the following ASP page:
The page is running in IIS under the local user IUser_computername.
When I run the same code with a domain account it successeds.
Thanks in advance,
Ido Friedman
<%
Dim dataSource
On Error Resume Next
Set cnn = Server.CreateObject("ADODB.Connection")
cnn.open "PROVIDER=SQLOLEDB;DATA
SOURCE=servername";UID=user;PWD=user;DATABASE=nort hwind"
If err.number = 0 Then
Response.Write(cnn.State)
cnn.Close
Else
Response.Write( err.Description )
End If
Response.End
%>
"Warren Brunk" wrote:

> Do you have mixed mode authentication enabled?
> To enable...
> SQL 2005
> In SQL Server Management Studio Object Explorer, right-click your server,
> and then click Properties.
> On the Security page, under Server authentication, select the new server
> authentication mode, and then click OK.
> In the SQL Server Management Studio dialog box, click OK, to acknowledge the
> need to restart SQL Server.
>
> SQL 2000
> Expand a server group.
>
> Right-click a server, and then click Properties.
>
> Click the Security tab.
>
> Under Authentication, click SQL Server and Windows.
>
> Under Audit level, select the level at which user accesses to Microsoft? SQL
> ServerT are recorded in the SQL Server error log:
> None causes no auditing to be performed.
>
> Success causes only successful login attempts to be audited.
>
> Failure causes only failed login attempts to be audited.
>
> All causes successful and failed login attempts to be audited.
>
> Hope that helps...
>
> --
> /*
> Warren Brunk - MCITP - SQL 2005, MCDBA
> www.techintsolutions.com
> */
>
> "Ido friedman" <Idofriedman@.discussions.microsoft.com> wrote in message
> news:934F22F5-2624-49B2-AC35-1970C1AE876D@.microsoft.com...
>
>

ConnectionString

Thanks for the reply, this is what I have tried:

E134017 is the name of my computer on the LAN
\\E134017.nw.nos.boeing.com is the full path
I think also \\E134017 can also be used to identify my computer to others on the lan/

The following connection string will work on my workstation only, others computers cannot find it or sql won't honor their request for data.

con As New SqlConnection("Data Source=E134017;trusted_connection=true;Initial Catalog=Database1")

I have also tried this string which runs locally but not from another lan location.

con As New SqlConnection("Data Source=\\E134017.nw.nos.boeing.com;trusted_connection=true;Initial Catalog=Database1")

&

con As New SqlConnection("Data Source=\\E134017;trusted_connection=true;Initial Catalog=Database1")

Could I be having an authentication problem with other computers or does the trusted_source=true eliminate authentication as a problem.

Fred Herring

Fred,
The users may not be able to Authenticate against your machine - you can use a Connectioon string such as the following:
Dim con As New SqlConnection("DataSource=E134017;Initial Catalog=;User ID=sa;Password=mypassword")
using a SQL Server account to authenticate with and insure that you have access. I don't believe the \\ in front of your machine name is required.
Thanks,
Tyler

Connection To SQL Server 2005 / 2000

Hi everybody,
I got a bit of a problem with my connection. I wrote a programm in VB.Net wich connects to a sql-server 2005. On my local Computer everything works great, but on another Computer in the Network, I just receving timeouts. I allready check, if the sever allows remote connection.
My connectionstring for the SQL connection looks like this:

"Initial Catalog=Bauvorhaben;Data Source=P4-2400\SQLEXPRESS;Password=?;Persist Security Info=True;User ID=Lars"

I allready tried to get an connection to SQL-Server 2000. But the same here.

Does somebody have a clue, why I can't connect?

Thanks,
Lars

By default SQLExpress do not allow remote conneciton.

You need to

1. Turn on remote connection using SQL Server configuration Manager.

2. Start sqlbrowser service that is collocated with the SQLExpress server. SQL Browser service is needed if the sqlserver is a name instance, such as sqlexpress.

3. Make sure you make exception for sqlservr.exe in the firewall configuration of windows.

http://blogs.msdn.com/sql_protocols/archive/2005/11/14/492616.aspx

connection to Analysis server failed

May you help for beginner.
I have installed MS SQL server 2005 to local computer. I can not connect to
Server type "Analysis Services" from Management studio.
Message "A connection cannot be made. Ensure that the server is running.
(Microsoft.AnalysisServices.AdomdClient)" appears.
But I can connect to the following Server types: Database Engine
Reporting service
Integration service
I have reinstalled application, but same behaviour.
Please, how I can ensure that AnalysisServices server is running?
Thank you for your help.
Zdenek
You can use the SQL Server Configuration Manager to check
the service.
Open up SQL Server Configuration Manager and on the left,
select SQL Server 2005 Services. On the right, check SQL
Server Analysis Services. You can start it from here if it's
not running and you can configure how, when you want the
service to start (manual, automatic, etc)
-Sue
On Sat, 17 Mar 2007 04:21:03 -0700, Zdenek
<Zdenek@.discussions.microsoft.com> wrote:

>May you help for beginner.
>I have installed MS SQL server 2005 to local computer. I can not connect to
>Server type "Analysis Services" from Management studio.
>Message "A connection cannot be made. Ensure that the server is running.
>(Microsoft.AnalysisServices.AdomdClient)" appears.
>But I can connect to the following Server types: Database Engine
>Reporting service
>Integration service
>I have reinstalled application, but same behaviour.
>Please, how I can ensure that AnalysisServices server is running?
>Thank you for your help.
>Zdenek

connection to Analysis server failed

May you help for beginner.
I have installed MS SQL server 2005 to local computer. I can not connect to
Server type "Analysis Services" from Management studio.
Message "A connection cannot be made. Ensure that the server is running.
(Microsoft.AnalysisServices.AdomdClient)" appears.
But I can connect to the following Server types: Database Engine
Reporting service
Integration service
I have reinstalled application, but same behaviour.
Please, how I can ensure that AnalysisServices server is running?
Thank you for your help.
ZdenekYou can use the SQL Server Configuration Manager to check
the service.
Open up SQL Server Configuration Manager and on the left,
select SQL Server 2005 Services. On the right, check SQL
Server Analysis Services. You can start it from here if it's
not running and you can configure how, when you want the
service to start (manual, automatic, etc)
-Sue
On Sat, 17 Mar 2007 04:21:03 -0700, Zdenek
<Zdenek@.discussions.microsoft.com> wrote:

>May you help for beginner.
>I have installed MS SQL server 2005 to local computer. I can not connect to
>Server type "Analysis Services" from Management studio.
>Message "A connection cannot be made. Ensure that the server is running.
>(Microsoft.AnalysisServices.AdomdClient)" appears.
>But I can connect to the following Server types: Database Engine
>Reporting service
>Integration service
>I have reinstalled application, but same behaviour.
>Please, how I can ensure that AnalysisServices server is running?
>Thank you for your help.
>Zdenek

Connection String to SQL Express on another computer

I have an XP Pro machine running a classic ASP site in IIS - the version that comes on the XP Pro CD. The site makes a connection to an MSDE database on the same machine named InControl. I have moved that database to SQL Express 2005 and want to test it with the ASP site. SQL Express 2005 is running on a separate Vista machine. I am currently using this connection string:

objConn.ConnectionString = "Provider=SQLOLEDB;Data Source=400SC;Initial Catalog=InControl;User ID=" & uid & ";Password=" & upass & ""

Where 400SC is the name of the XP Pro machine and InControl is the database. The variables uid and upass are pulled from Session when the connection string is created.

I have tried different Provider names and various combinations of server name and ip address with and without port numbers for the Data Source. All of them yield some variation of this error:

Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

What should the connection string look like?

Thanks for the help.

PS - If the solution involves a port, do I need to make that port an exception in the Vista Firewall?

The sqlexpress server may have an instance name. Try changing it to "Data Source=400SC\SQLEXPRESS"

|||

This is the string I initially tried to access SQL Express on the other computer - CSC_DELL. I recieved the error message in the original post. Hard coding the User ID and Password also yeilds the same error. The User is set-up in SQL and the database.

objConn.ConnectionString = "Provider=SQLOLEDB;Data Source=CSC_DELL\SQLEXPRESS;Initial Catalog=InControl;User ID=" & uid & ";Password=" & upass & ""

|||

Create a new file on your desktop. Rename the file to "test.udl" Double-click the file, and create a connection to your database. Once the "Test Connection" succeeds, then close the dialog box and view the contents of your .udl file in notepad. This will give you a connection string to compare against.

|||

Created a .udl file, but the SQL Express server on the Vista machine was not listed in the Server drop down list. I used the SQL Configuration tool and enabled listening with TCP/IP and Named Pipes - both were disabled. Also made a 1433 port exception in the Vista firewall. Tried udl, again, and the server still did not show. Both computers are in the same workgroup on my home network. I tried typing the name of the SQL Express server in the drop down list - didn't work. Everything I try yields the "SQL Server does not exist or access denied." Still stuck.

Connection String Problem : Quantasoft !

Hello ! i just thought to give it a try to see if it works or not!, i made a webpage inC# and it worked fine on my computer but when i uploaded on the internet i got error !!.- SERVER "/" error - runtime error .!!!. then I tested it without any database and found it to work fine ! but when i do any database connectivity my webpage gives errors on the internet !!.. So i got that there is a PROBLEM IN CONNECTION STRING.

Here is what i did!...... I right-clicked the APP_DATA and added a DATABASE named TEST.MDF. Then i added a TABLE named TEST in TEST.MDF and added some fields. Then i dragged the table to the designer view and thus it created a GRIDVIEW and a SQLDATASOURCE1. Thats it !!. it showed all the fields when i ran it on the computer by pressing F5. !!

Everything Ran fine on my computer ! but when i uploaded the website on the internet it showed runtime errors !!

I created a FREE account in Quantasoft web hosting and they had a condition that says -"MS SQLServer2005 Express Edition only User Instances"- I DONT KNOW WHAT IT MEANS !! so i carried on with the uploading stuff !. after uploading i read that the database should be in the APP_DATA folder and i did it !. then it was written to put my database name and it generated a connection string which was-THIS IS WHAT THEY GAVE ME =:<add name="LocalSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;Database=abcd.qsh.in_5f2a2114-ebeb-4252-463a-6b1f8cfc3f14;AttachDBFilename=|DataDirectory|test" /> . BUT i had a different connection string ! and that was -THIS IS WHAT I HAD ALREADY->><addname="testConnectionString1"connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\test.mdf;Integrated Security=True;User Instance=True"providerName="System.Data.SqlClient"/> So i deleted my connection string and replaced it with this string ! but still it didnt worked !!.

WHAT DO I NEED TO DO !? HELP ME.
PLEASE TELL ME HOW TO CONVERT MY CONNECTION STRING !
I also found out one more post relating to my problem please read it because somebody replied about some ASPNETDB i also dont know about aspnetdb!! -http://forums.asp.net/t/1122922.aspx

Also, i viewed some starter kits and they also had a ASPNETDB.mdf and someother.mdf in their APP_DATA folder ! . what is ASPNETDB ??.. Do i also need it ? where do i make it or get it !? please explain all about this! i dont know anything about this !

Thanks in advance.

Hi ashutosh508,

ASPNETDB is introduced from asp.net 2.0 and is used to manage profiles/membersips/roles/etc, you can access it from your web site administration tool. Generally speaking, if you do not implement profiles/membership/roles features in your application, you do not need to build this database(actually this database can also be build automatically).

THIS IS WHAT THEY GAVE ME =:<add name="LocalSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;Database=abcd.qsh.in_5f2a2114-ebeb-4252-463a-6b1f8cfc3f14;AttachDBFilename=|DataDirectory|test" /> . BUT i had a different connection string ! and that was -THIS IS WHAT I HAD ALREADY->><addname="testConnectionString1"connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\test.mdf;Integrated Security=True;User Instance=True"providerName="System.Data.SqlClient"/>

I think your connection string is correct and the one they provided you is wrong. Based on my understanding, since we have specified to use AttachDBfile automatically, we cannot specify theDatabase name--actually i think the database name will be generated automatically after the database file(mdf) is attached.

Any way, you need to consult your web hosting company for more details. Hope my suggestion helps

connection string

I have made an app (the first one) and im trying to find the right connection string to the database. Im using sqlexpress on my local computer, and my host uses MSSQL, can anyone tell me what the connection string could

Checkwww.connectionstrings.com

Connection problems

Hello everyone.

I have installed SQL Server 2005 on a computer. The problem is that when I try to connect to it through Microsoft SQL Server Management Studio, I have to retry to connect several times before it gets connected finally.

I get the following error when it fails to connect:

An error has occured while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (Provider: SQL Network Interfaces. error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server).

Event viewer error - Application

The SQLBrowser is enabling SQL instance and connectivity discovery support.

Event viewer error - System

The SQL Server Browser service terminated unexpectedly. It has done this 2848 time(s). The following corrective action will be taken in 60000 milliseconds: Restart the service.

Also, when I try to start the SQL Server Browser, I get the following error:

The request failed or the service did not start in a timely fashion. Consult the event liog or other applicable logs for details.

Does anyone out there have a clue to this?

Thanks in advance.

Hemant

Try installing the most recent service pack on the machine. Sounds like you have a corrupt file which the SQL Browser requires to function.

Connection problems

Hello everyone.

I have installed SQL Server 2005 on a computer. The problem is that when I try to connect to it through Microsoft SQL Server Management Studio, I have to retry to connect several times before it gets connected finally.

I get the following error when it fails to connect:

An error has occured while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (Provider: SQL Network Interfaces. error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server).

Event viewer error - Application

The SQLBrowser is enabling SQL instance and connectivity discovery support.

Event viewer error - System

The SQL Server Browser service terminated unexpectedly. It has done this 2848 time(s). The following corrective action will be taken in 60000 milliseconds: Restart the service.

Also, when I try to start the SQL Server Browser, I get the following error:

The request failed or the service did not start in a timely fashion. Consult the event liog or other applicable logs for details.

Does anyone out there have a clue to this?

Thanks in advance.

Hemant

Try installing the most recent service pack on the machine. Sounds like you have a corrupt file which the SQL Browser requires to function.

Connection problem: ASP.NET on machine and SQL Server on another

If anyone knows the answer to this Id me greatly appreciative.
I am not on a domain.
I have SQL Server sitting on computer A
Computer A has:
Windows XP SP2
SQL Server 2000 SP3a
SQL Server is set to use Trusted or SQL authorization
I have added a user X to SQL Server with a password of X
I am writing an ASP.NET app on Computer B. IIS and Dev on B)
I am trying to make a connection to SQL on computer A but get the
error SQL Server does not exist or access denied
Now when I create a small Winforms app as a test, I can use the exact
same connection string and open a connection to SQL Server just fine.
So, Im guessing the problems lies in the security of ASP.NET, but Im
not sure what to change to make this work.
Anyone with any ideas?
TIA
B
I should also point out, I can also connect just fine withn the same
user/pw with Enterprise Mager, and Query Analyzer as well as add the
connection to Visual Studio.
B
Brian W wrote:

> If anyone knows the answer to this Id me greatly appreciative.
> I am not on a domain.
> I have SQL Server sitting on computer A
> Computer A has:
> Windows XP SP2
> SQL Server 2000 SP3a
> SQL Server is set to use Trusted or SQL authorization
> I have added a user X to SQL Server with a password of X
> I am writing an ASP.NET app on Computer B. IIS and Dev on B)
> I am trying to make a connection to SQL on computer A but get the
> error SQL Server does not exist or access denied
> Now when I create a small Winforms app as a test, I can use the exact
> same connection string and open a connection to SQL Server just fine.
> So, Im guessing the problems lies in the security of ASP.NET, but Im
> not sure what to change to make this work.
> Anyone with any ideas?
> TIA
> B

Connection problem: ASP.NET on machine and SQL Server on another

If anyone knows the answer to this Id me greatly appreciative.
I am not on a domain.
I have SQL Server sitting on computer A
Computer A has:
Windows XP SP2
SQL Server 2000 SP3a
SQL Server is set to use Trusted or SQL authorization
I have added a user X to SQL Server with a password of X
I am writing an ASP.NET app on Computer B. IIS and Dev on B)
I am trying to make a connection to SQL on computer A but get the
error SQL Server does not exist or access denied
Now when I create a small Winforms app as a test, I can use the exact
same connection string and open a connection to SQL Server just fine.
So, Im guessing the problems lies in the security of ASP.NET, but Im
not sure what to change to make this work.
Anyone with any ideas?
TIA
BI should also point out, I can also connect just fine withn the same
user/pw with Enterprise Mager, and Query Analyzer as well as add the
connection to Visual Studio.
B
Brian W wrote:

> If anyone knows the answer to this Id me greatly appreciative.
> I am not on a domain.
> I have SQL Server sitting on computer A
> Computer A has:
> Windows XP SP2
> SQL Server 2000 SP3a
> SQL Server is set to use Trusted or SQL authorization
> I have added a user X to SQL Server with a password of X
> I am writing an ASP.NET app on Computer B. IIS and Dev on B)
> I am trying to make a connection to SQL on computer A but get the
> error SQL Server does not exist or access denied
> Now when I create a small Winforms app as a test, I can use the exact
> same connection string and open a connection to SQL Server just fine.
> So, Im guessing the problems lies in the security of ASP.NET, but Im
> not sure what to change to make this work.
> Anyone with any ideas?
> TIA
> B

Connection Problem when Installed SQL Ser 2000 & SQL Server 2005

Hi All!

In my computer I have Installed MS SQL Server 2005(Default Instance) & MS SQL Server 2000(Duynnh Instance). When I write an ASP.NET app to connect to SQL Server 2005 it's OK but not connect in SQL Server 2000. Please give me the SQL Connection string to connect to SQL Server 2000.

When I open Query analyzer connection is OK for both.

Thanks.

This is an awesome site i use to get connection string formats

http://www.connectionstrings.com/

Another easy way to get connection strings is to drag and drop and data adapter or a table from a database in server explorer, and look at the connection string it builds.

|||

I think sql2000 and sql2005 use the same kind of connection string--both use the same sql server provider. You only need to check if you have specified the correct instance name, default database, login account/psw (if you use sql authentication mode) in your sql2000 connection string.

Hope my suggestion helps

Connection problem after installing msde2000a

Hi everyone,
I just installed on my windows 2000 computer using the following command
line with a strong sa password:
c:> setup sapwd="my_password". I want to create a new access database
project (.adp) but after I input the credentials for sa and user, I get a
message saying that SQL Server doesn't exist or access denied. I specified
the name of the computer in the server name dropdown during one try and it
failed. Then I specified (local) in the same dropdown and it failed again.
1- Can somebody give me a clue about what Happenned?
2- Can somebody provide me with a URL where I can download msde2000 NOT
msde2000a (which is nightmare to configure)? When I installed msde2000 I
didn't have all those problems.
Thanks
hi,
Zadi Friedrich wrote:
> Hi everyone,
> I just installed on my windows 2000 computer using the following
> command line with a strong sa password:
> c:> setup sapwd="my_password". I want to create a new access database
> project (.adp) but after I input the credentials for sa and user, I
> get a message saying that SQL Server doesn't exist or access denied.
> I specified the name of the computer in the server name dropdown
> during one try and it failed. Then I specified (local) in the same
> dropdown and it failed again. 1- Can somebody give me a clue about
> what Happenned? 2- Can somebody provide me with a URL where I can
> download msde2000 NOT msde2000a (which is nightmare to configure)?
> When I installed msde2000 I didn't have all those problems.
> Thanks
MSDE installs by default disabling standard SQL Server connections and only
allowing trusted WinNT connections...
you can modify this behavior both at install time, providing the
SECURITYMODE=SQL
parameter to the setup.exe boostrap installer, or later, at run time,
"hacking" the Windows registry as described in
http://support.microsoft.com/default...b;en-us;285097
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3k76mdFt0vekU1@.individual.net...
> hi,
> Zadi Friedrich wrote:
> MSDE installs by default disabling standard SQL Server connections and
> only allowing trusted WinNT connections...
> you can modify this behavior both at install time, providing the
> SECURITYMODE=SQL
> parameter to the setup.exe boostrap installer, or later, at run time,
> "hacking" the Windows registry as described in
> http://support.microsoft.com/default...b;en-us;285097
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
you can also change that by going to the service right-click on SQL server
instance then go properties.
under the security tab you will be able to change for SQL Server and
Windows.
then stop the service, restart it and enjoy !.>