Couldn't start sqlagent service

I found the sqlagent stopped, I try to start it from
service window, it return a message: couldn't start
sqlagent$instance on local computer, the service didn't
return a error, this could by a internal windows error or
internal service error. The sqlagent use domain admin
account, and when I use my local EM, I can open the node,
database. But when I use terminal service to login in to
that server, then I can't use the server's EM to connect
that instance. The message said: a connection can't be
established. Reason: SQL server doesn't exist or access
denied. Can anyone give me a hint? Thanks in advance.
HarryWe had similar problem when the registry of a machine was messed up with a
restore of a drive image. Your problem sounds also like a registry or
Advanced Directory problem. Check with your sysadmin.
Quentin
"Harry Guo" <anonymous@.discussions.microsoft.com> wrote in message
news:2d79c01c46a75$98d28d70$a401280a@.phx
.gbl...
> I found the sqlagent stopped, I try to start it from
> service window, it return a message: couldn't start
> sqlagent$instance on local computer, the service didn't
> return a error, this could by a internal windows error or
> internal service error. The sqlagent use domain admin
> account, and when I use my local EM, I can open the node,
> database. But when I use terminal service to login in to
> that server, then I can't use the server's EM to connect
> that instance. The message said: a connection can't be
> established. Reason: SQL server doesn't exist or access
> denied. Can anyone give me a hint? Thanks in advance.
> Harrysql

Couldn't start sqlagent service

I found the sqlagent stopped, I try to start it from
service window, it return a message: couldn't start
sqlagent$instance on local computer, the service didn't
return a error, this could by a internal windows error or
internal service error. The sqlagent use domain admin
account, and when I use my local EM, I can open the node,
database. But when I use terminal service to login in to
that server, then I can't use the server's EM to connect
that instance. The message said: a connection can't be
established. Reason: SQL server doesn't exist or access
denied. Can anyone give me a hint? Thanks in advance.
HarryWe had similar problem when the registry of a machine was messed up with a
restore of a drive image. Your problem sounds also like a registry or
Advanced Directory problem. Check with your sysadmin.
Quentin
"Harry Guo" <anonymous@.discussions.microsoft.com> wrote in message
news:2d79c01c46a75$98d28d70$a401280a@.phx.gbl...
> I found the sqlagent stopped, I try to start it from
> service window, it return a message: couldn't start
> sqlagent$instance on local computer, the service didn't
> return a error, this could by a internal windows error or
> internal service error. The sqlagent use domain admin
> account, and when I use my local EM, I can open the node,
> database. But when I use terminal service to login in to
> that server, then I can't use the server's EM to connect
> that instance. The message said: a connection can't be
> established. Reason: SQL server doesn't exist or access
> denied. Can anyone give me a hint? Thanks in advance.
> Harry

Couldn't start sqlagent service

I found the sqlagent stopped, I try to start it from
service window, it return a message: couldn't start
sqlagent$instance on local computer, the service didn't
return a error, this could by a internal windows error or
internal service error. The sqlagent use domain admin
account, and when I use my local EM, I can open the node,
database. But when I use terminal service to login in to
that server, then I can't use the server's EM to connect
that instance. The message said: a connection can't be
established. Reason: SQL server doesn't exist or access
denied. Can anyone give me a hint? Thanks in advance.
Harry
We had similar problem when the registry of a machine was messed up with a
restore of a drive image. Your problem sounds also like a registry or
Advanced Directory problem. Check with your sysadmin.
Quentin
"Harry Guo" <anonymous@.discussions.microsoft.com> wrote in message
news:2d79c01c46a75$98d28d70$a401280a@.phx.gbl...
> I found the sqlagent stopped, I try to start it from
> service window, it return a message: couldn't start
> sqlagent$instance on local computer, the service didn't
> return a error, this could by a internal windows error or
> internal service error. The sqlagent use domain admin
> account, and when I use my local EM, I can open the node,
> database. But when I use terminal service to login in to
> that server, then I can't use the server's EM to connect
> that instance. The message said: a connection can't be
> established. Reason: SQL server doesn't exist or access
> denied. Can anyone give me a hint? Thanks in advance.
> Harry

couldn't see some of the database in the object explorer window of Management Studio

hey guys,
I have one question. But it is not related with the Reporting Service. I got my computer set up with SQL Server 2005 version yesterday. When I connect to the database engine, I can see only system databases(master,model,msdb and tempdb) under the system database folder. I couldn't see other databases(like pubs,northwind) in the object explorer window of Management Studio. Do you have any idea how to solve this difficulty?

Thanks.

Amde

Hi,

no problem there. These databases aren′t installed by default. There are scripts to build up the database from scratch:

http://www.microsoft.com/downloads/details.aspx?FamilyID=06616212-0356-46A0-8DA2-EEBC53A68034&displaylang=en

Or you use the Adventureworks sample database:

http://www.microsoft.com/downloads/details.aspx?FamilyID=e719ecf7-9f46-4312-af89-6ad8702e4e6e&DisplayLang=en

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Thanks a lot. I will work on that.

Amde

Couldn't see some databases in the object explorer window of Mangement Studio

hey guys,
I have one question. But it is not related with the Reporting Service. I got my computer set up with SQL Server 2005 version yesterday. When I connect to the database engine, I can see only system databases(master,model,msdb and tempdb) under the system database folder. I couldn't see other databases(like pubs,northwind) in the object explorer window of Management Studio. Do you have any idea how to solve this difficulty?

Thanks.

Amde

Pubs and northwind are no longer installed by default.|||

How about the other databases like Adventurework db? If you have some idea how to configure the database engine, please let me know.

I appreciate your response.

Amde

|||

Adventureworks is not installed by default either. Your questions are more appropriately suited for the "SQL Server Tools General" forum. http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=84&SiteID=1.

An easy test is to simply create a new database, refresh the object explorer, and you should see it there.

I am not certain what the best way to install the sample databases is post-installation. You should ask that question either in the tools forum or the setup forum (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=95&SiteID=1).

|||

Thank you for your advise. I will post this question on the appropriate form discussion board.

|||

Hi, Amde --

This content will be available in the next version of BOL --

Before you can use SQL Server 2005 samples, you must install them. Installing the samples is a two-step process. Samples are not installed by default and SQL Server Setup does not run the sample installation program for you. First, when running setup, on the Features Component page, select Samples. This will copy the samples installation program to your computer during setup. Second, to run the samples installation program, point to the Start menu, point to All Programs, point to Microsoft SQL Server 2005, point to Documentation and Samples, point to Samples, and click Microsoft SQL Server 2005 Samples. To get the most recent samples, uninstall your current samples, and download and install the latest SQL Server 2005 samples from the Microsoft download Web site. To uninstall the current version of samples, point to the Start menu, point to Control Panel, and click Add or Remove Programs. Click Microsoft SQL Server 2005 Samples, and then click Remove. To find the most current samples, search http://www.microsoft.com/downloads/ for “SQL Server 2005 Samples and Sample Databases”. Choose the edition that matches your Reporting Services installation.

-- Mary

Couldn't see some databases in the object explorer window of Mangement Studio

hey guys,
I have one question. But it is not related with the Reporting Service. I got my computer set up with SQL Server 2005 version yesterday. When I connect to the database engine, I can see only system databases(master,model,msdb and tempdb) under the system database folder. I couldn't see other databases(like pubs,northwind) in the object explorer window of Management Studio. Do you have any idea how to solve this difficulty?

Thanks.

Amde

Pubs and northwind are no longer installed by default.|||

How about the other databases like Adventurework db? If you have some idea how to configure the database engine, please let me know.

I appreciate your response.

Amde

|||

Adventureworks is not installed by default either. Your questions are more appropriately suited for the "SQL Server Tools General" forum. http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=84&SiteID=1.

An easy test is to simply create a new database, refresh the object explorer, and you should see it there.

I am not certain what the best way to install the sample databases is post-installation. You should ask that question either in the tools forum or the setup forum (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=95&SiteID=1).

|||

Thank you for your advise. I will post this question on the appropriate form discussion board.

|||

Hi, Amde --

This content will be available in the next version of BOL --

Before you can use SQL Server 2005 samples, you must install them. Installing the samples is a two-step process. Samples are not installed by default and SQL Server Setup does not run the sample installation program for you. First, when running setup, on the Features Component page, select Samples. This will copy the samples installation program to your computer during setup. Second, to run the samples installation program, point to the Start menu, point to All Programs, point to Microsoft SQL Server 2005, point to Documentation and Samples, point to Samples, and click Microsoft SQL Server 2005 Samples. To get the most recent samples, uninstall your current samples, and download and install the latest SQL Server 2005 samples from the Microsoft download Web site. To uninstall the current version of samples, point to the Start menu, point to Control Panel, and click Add or Remove Programs. Click Microsoft SQL Server 2005 Samples, and then click Remove. To find the most current samples, search http://www.microsoft.com/downloads/ for “SQL Server 2005 Samples and Sample Databases”. Choose the edition that matches your Reporting Services installation.

-- Mary

sql

Could not start the SQL Server Reporting Services (REPORTS) service on local computer.

Error 1069. The service did not start due to login failure.

I can't get a domain login account with domain admin rights to start the service. The only way I can start the service is with the LocalSystem account, which isn't a good solution because it's not networkable.

Thank you for any advice you have.

Does your domain account has "Log on as a service" right?|||Yes. My domain account has it in Active Directory and on the server under Local Security Policy.|||Interesting ... can you run any other service with your domain account? Is this problem specific to RS service?|||I just tested stopping and starting another service with the same domain account and it ran that service successfully. It appears that the problem is just related to SQL Server Reporting Services.|||Perhaps the password changed and your RS service still has the old password? Sorry I can't think of anything else.|||

How do I know what password the RS Service has or should be? I know the password hasn't changed for our domain account. I verified it works for other services.

Here is more information:

I have two servers:

One database server: SQL Server 2005 SP1

One web server with IIS running multiple websites with ASP 1.1 and ASP 2.0 and SQL Server 2005 Reporting Services. I configured Reporting Services from my web server where my SQL Server Reporting Services account is that won't login as a domain administrator account with administrator rights and log on as a service rights.

Is there some other type of rights that may be missing related to SQL Server Reporting services?

|||Also, I found that the WebServiceAccount was not set in the RSreportserver.config file in Program Fiels\Microsoft SQL Servre\MSSQL.1\Reporting Services\ReportManager so I set it to IWAM_ComputerName with the ComputerName as the name of my computer. Then I tried restarted the Reporting Services service, but it didn't start. I also can't get the ASP.NET service to start. I tried to start it using the IWAM_ComputerName account, but I need to figure out what the password is for that account to start the service.|||

rsreportserver.config file should be in ...\MSSQL.1\Reporting Services\ReportServer directory. To set web service account, please use the configuration tool. Setting it to IWAM_ account is incorrect. On XP/Win2K, the web service account is by default <MachineName>\ASPNET. On Win2K3 it is the app pool identity of your report server virtual directory.

When you say you can't get ASP.NET to start, what did you try? You shouldn't do anything. The ASP.NET worker process should start when the first request is received.

|||

The configuration tool doesn't grab the ASP.NET account web service. It won't pick it up or let me type it in. The service is listed in Services, but wasn't started. The only way it would start was with a login of LocalSystem.

In another website, http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=17756&SiteID=1, a Microsoft Lead Reporting Services person, Tudor Trufinescu, recommended added the Web Service Account if it was missing in the config file.

I'll remove it though.

The article also said that if I'm using IIS 5, which I assume I'm using since I have Windows 2000 Advanced Server, that the ASP.NET account should login using MACHINE\ASPNET account. This never worked. I had to change it to the LocalSystem login to work. I thought this problem may be related to the Reporting Services problem since it's an option in the Configuration Tools that isn't configured.

Thank you.

|||

The configuration tool should pick up ASP.NET account from machine.config file. It will not let you type in if you are on IIS5. Are you seeing blank "ASP.NET service account" box?

I am still confused when you talk about "starting the service". Which service is this? (What is the name of the service in service controller manager?) RS has a windows service that is named "SQL Server Reporting Services". On IIS side, you don't control ASP.NET worker process identity since you are on Win2K/IIS5.

|||

Yes. I am seeing a blank ASP.NET service account box.

The two services I was referencing were:

SQL Server Rerporting Service - will only start with a logon of LocalSystem account - not a good solution because I need to use a domain account that will login across the network into a database.

ASPNET service - will only start with the LocalSystem account. I just mentioned this to note it. Wasn't sure if it also needed to start using some other type of login.

Could not start the MSSQLServer Service on local computer. Error: 1068: the dependency ser

We installed SQL Server 2000 on a Win2000 server (call it serverA). This
Win2000 server used to be a member server of a Domain Controller (call it
serverDC with domain name DCName). We had a problem with that Domain
Controller today, so we took out serverA from the domain controller. Now, we
cannot start the SQL Server Service Manager. It gave us an error that says
"Dependency service or group failed to start. Error 1068 (Dependency service
or group failed to start) occured while performing this service operation on
the MSSQLServer Service.".
When I tried to srtart the MSSQLServer Service, it gave me an error "Could
not start the MSSQLServer Service on local computer. Error: 1068: the
dependency service or group failed to start". When I clicked on the tab
"Dependencies", there is no dependency for this service.
On the "Log On" tab of MSSQLServer Service, the user name used to say
"DCName\Administrator", and after we took out serverA from the domain
controller, we changed the user name to "\Administrator".
How can I fix this problem ? Thank you.Try changing the services (SQL Server, SQL Agent, etc) to
run under Local System - from the Log On tab of the service.
You wouldn't necessarily want to keep it set to this but you
can see if it's starts up with the services running under
local system.
-Sue
On Tue, 7 Sep 2004 14:49:06 -0500, "Fie Fie Niles"
<fniles@.wincitesystems.com> wrote:
>We installed SQL Server 2000 on a Win2000 server (call it serverA). This
>Win2000 server used to be a member server of a Domain Controller (call it
>serverDC with domain name DCName). We had a problem with that Domain
>Controller today, so we took out serverA from the domain controller. Now, we
>cannot start the SQL Server Service Manager. It gave us an error that says
>"Dependency service or group failed to start. Error 1068 (Dependency service
>or group failed to start) occured while performing this service operation on
>the MSSQLServer Service.".
>When I tried to srtart the MSSQLServer Service, it gave me an error "Could
>not start the MSSQLServer Service on local computer. Error: 1068: the
>dependency service or group failed to start". When I clicked on the tab
>"Dependencies", there is no dependency for this service.
>On the "Log On" tab of MSSQLServer Service, the user name used to say
>"DCName\Administrator", and after we took out serverA from the domain
>controller, we changed the user name to "\Administrator".
>How can I fix this problem ? Thank you.
>

Could not start the ASP.NET service on local computer.

Error 1069. The service did not start due to login failure.

I can't get a domain login account with domain admin rights to start the service. The only way I can start the service is with the LocalSystem account, which isn't a good solution because it's not networkable.

Thank you for any advice you have.

Does your domain account has "Log on as a service" right?|||Yes. My domain account has it in Active Directory and on the server under Local Security Policy.|||Interesting ... can you run any other service with your domain account? Is this problem specific to RS service?|||I just tested stopping and starting another service with the same domain account and it ran that service successfully. It appears that the problem is just related to SQL Server Reporting Services.|||Perhaps the password changed and your RS service still has the old password? Sorry I can't think of anything else.|||

How do I know what password the RS Service has or should be? I know the password hasn't changed for our domain account. I verified it works for other services.

Here is more information:

I have two servers:

One database server: SQL Server 2005 SP1

One web server with IIS running multiple websites with ASP 1.1 and ASP 2.0 and SQL Server 2005 Reporting Services. I configured Reporting Services from my web server where my SQL Server Reporting Services account is that won't login as a domain administrator account with administrator rights and log on as a service rights.

Is there some other type of rights that may be missing related to SQL Server Reporting services?

|||Also, I found that the WebServiceAccount was not set in the RSreportserver.config file in Program Fiels\Microsoft SQL Servre\MSSQL.1\Reporting Services\ReportManager so I set it to IWAM_ComputerName with the ComputerName as the name of my computer. Then I tried restarted the Reporting Services service, but it didn't start. I also can't get the ASP.NET service to start. I tried to start it using the IWAM_ComputerName account, but I need to figure out what the password is for that account to start the service.|||

rsreportserver.config file should be in ...\MSSQL.1\Reporting Services\ReportServer directory. To set web service account, please use the configuration tool. Setting it to IWAM_ account is incorrect. On XP/Win2K, the web service account is by default <MachineName>\ASPNET. On Win2K3 it is the app pool identity of your report server virtual directory.

When you say you can't get ASP.NET to start, what did you try? You shouldn't do anything. The ASP.NET worker process should start when the first request is received.

|||

The configuration tool doesn't grab the ASP.NET account web service. It won't pick it up or let me type it in. The service is listed in Services, but wasn't started. The only way it would start was with a login of LocalSystem.

In another website, http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=17756&SiteID=1, a Microsoft Lead Reporting Services person, Tudor Trufinescu, recommended added the Web Service Account if it was missing in the config file.

I'll remove it though.

The article also said that if I'm using IIS 5, which I assume I'm using since I have Windows 2000 Advanced Server, that the ASP.NET account should login using MACHINE\ASPNET account. This never worked. I had to change it to the LocalSystem login to work. I thought this problem may be related to the Reporting Services problem since it's an option in the Configuration Tools that isn't configured.

Thank you.

|||

The configuration tool should pick up ASP.NET account from machine.config file. It will not let you type in if you are on IIS5. Are you seeing blank "ASP.NET service account" box?

I am still confused when you talk about "starting the service". Which service is this? (What is the name of the service in service controller manager?) RS has a windows service that is named "SQL Server Reporting Services". On IIS side, you don't control ASP.NET worker process identity since you are on Win2K/IIS5.

|||

Yes. I am seeing a blank ASP.NET service account box.

The two services I was referencing were:

SQL Server Rerporting Service - will only start with a logon of LocalSystem account - not a good solution because I need to use a domain account that will login across the network into a database.

ASPNET service - will only start with the LocalSystem account. I just mentioned this to note it. Wasn't sure if it also needed to start using some other type of login.

sql

Could not start the ASP.NET service on local computer.

Error 1069. The service did not start due to login failure.

I can't get a domain login account with domain admin rights to start the service. The only way I can start the service is with the LocalSystem account, which isn't a good solution because it's not networkable.

Thank you for any advice you have.

Does your domain account has "Log on as a service" right?|||Yes. My domain account has it in Active Directory and on the server under Local Security Policy.|||Interesting ... can you run any other service with your domain account? Is this problem specific to RS service?|||I just tested stopping and starting another service with the same domain account and it ran that service successfully. It appears that the problem is just related to SQL Server Reporting Services.|||Perhaps the password changed and your RS service still has the old password? Sorry I can't think of anything else.|||

How do I know what password the RS Service has or should be? I know the password hasn't changed for our domain account. I verified it works for other services.

Here is more information:

I have two servers:

One database server: SQL Server 2005 SP1

One web server with IIS running multiple websites with ASP 1.1 and ASP 2.0 and SQL Server 2005 Reporting Services. I configured Reporting Services from my web server where my SQL Server Reporting Services account is that won't login as a domain administrator account with administrator rights and log on as a service rights.

Is there some other type of rights that may be missing related to SQL Server Reporting services?

|||Also, I found that the WebServiceAccount was not set in the RSreportserver.config file in Program Fiels\Microsoft SQL Servre\MSSQL.1\Reporting Services\ReportManager so I set it to IWAM_ComputerName with the ComputerName as the name of my computer. Then I tried restarted the Reporting Services service, but it didn't start. I also can't get the ASP.NET service to start. I tried to start it using the IWAM_ComputerName account, but I need to figure out what the password is for that account to start the service.|||

rsreportserver.config file should be in ...\MSSQL.1\Reporting Services\ReportServer directory. To set web service account, please use the configuration tool. Setting it to IWAM_ account is incorrect. On XP/Win2K, the web service account is by default <MachineName>\ASPNET. On Win2K3 it is the app pool identity of your report server virtual directory.

When you say you can't get ASP.NET to start, what did you try? You shouldn't do anything. The ASP.NET worker process should start when the first request is received.

|||

The configuration tool doesn't grab the ASP.NET account web service. It won't pick it up or let me type it in. The service is listed in Services, but wasn't started. The only way it would start was with a login of LocalSystem.

In another website, http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=17756&SiteID=1, a Microsoft Lead Reporting Services person, Tudor Trufinescu, recommended added the Web Service Account if it was missing in the config file.

I'll remove it though.

The article also said that if I'm using IIS 5, which I assume I'm using since I have Windows 2000 Advanced Server, that the ASP.NET account should login using MACHINE\ASPNET account. This never worked. I had to change it to the LocalSystem login to work. I thought this problem may be related to the Reporting Services problem since it's an option in the Configuration Tools that isn't configured.

Thank you.

|||

The configuration tool should pick up ASP.NET account from machine.config file. It will not let you type in if you are on IIS5. Are you seeing blank "ASP.NET service account" box?

I am still confused when you talk about "starting the service". Which service is this? (What is the name of the service in service controller manager?) RS has a windows service that is named "SQL Server Reporting Services". On IIS side, you don't control ASP.NET worker process identity since you are on Win2K/IIS5.

|||

Yes. I am seeing a blank ASP.NET service account box.

The two services I was referencing were:

SQL Server Rerporting Service - will only start with a logon of LocalSystem account - not a good solution because I need to use a domain account that will login across the network into a database.

ASPNET service - will only start with the LocalSystem account. I just mentioned this to note it. Wasn't sure if it also needed to start using some other type of login.

Could not create an instance of OLE DB provider 'Microsoft.Jet

Thanks for the replies.I changed C: to C$ but I still get the same error.
The machineNameOnNetwork is my local computer name which is on the corporate
network.Where am i going wrong?
Thanks for your help.
"Omnibuzz" wrote:

> A few pointers. Don't know whcih one is applicable for you though
> 1. If you are accessing a network share ,then the account in which SQL
> Server is running should have access to that share.
> 2. Do not use C:, use C$ like this..
> \\machineNameOnNetwork\c$\Test.mdb;"
> Hope this helps.Is your machine shared on the network?
i.e.
Can you access c:\test.mdb from another PC?
Is the database also running on your PC?
"tech77" <tech77@.discussions.microsoft.com> wrote in message
news:993B9891-0894-4046-AB32-A098D36C0FAD@.microsoft.com...
> Thanks for the replies.I changed C: to C$ but I still get the same error.
> The machineNameOnNetwork is my local computer name which is on the
corporate
> network.Where am i going wrong?
> Thanks for your help.
>
> "Omnibuzz" wrote:
>|||Not the account in which you have connected to SQL Server.
The account in which the SQL Server Service is running should have access to
your machine and your folder.
Or the best way is to copy this file to a folder in your SQL Server and use
that path in the ODS.|||thanks Omnibuzz,Jim and Mark for your responses.
.The machine on which SQL Server is running might not have access to my
machine and my folder.Its on a remote server.
And I cannot configure that machine so it has access to my machine.
So I have to install SQL Server locally else I cant accomplish what I am
trying to do or is there some workaround?
thanks
"Omnibuzz" wrote:

> Not the account in which you have connected to SQL Server.
> The account in which the SQL Server Service is running should have access
to
> your machine and your folder.
> Or the best way is to copy this file to a folder in your SQL Server and us
e
> that path in the ODS.|||Create a share on your system, and put the mdb file in it. Enable the guest
account for your system, and give the guest user write permissions to the
file (both through-share, and NTFS if necessary).
You'll have to enable the guest account for it to work, because the SQL
server is more than likely running under the Local System context on the
system it resides on. Local System has no authority over the network, so whe
n
the SQL system tries to connect to you, it appears as guest.
Another method involves trusting the SQL server for delagation, but since
you said you can't modify it, it's not worth going into detail.
HTH
"tech77" wrote:
> thanks Omnibuzz,Jim and Mark for your responses.
> .The machine on which SQL Server is running might not have access to my
> machine and my folder.Its on a remote server.
> And I cannot configure that machine so it has access to my machine.
> So I have to install SQL Server locally else I cant accomplish what I am
> trying to do or is there some workaround?
> thanks
>
> "Omnibuzz" wrote:
>|||You can put the MDB on the database server, instead of your PC. Make it a
share if others need access to it.
You can put the MDB on a network server that the SQL Server account would
have access to.
You can grant the SQL Server account access to the MDB on your machine.
(the above two require proper network security, but should not be difficult)
You can drop the MDB database entirely and move the tables to SQL Server,
which is probably the best bet. If you absolutely need to access these
tables via MS Access, you can create linked tables pointing to SQL Server.
This will put all the tables local in SQL Server, but still let you use your
access front end.
Is there really a need to have SQL server access your local MDB, rather than
migrating the tables and data to SQL Server?
"tech77" <tech77@.discussions.microsoft.com> wrote in message
news:7B9F4484-F46C-493F-8830-A5602EC96B55@.microsoft.com...
> thanks Omnibuzz,Jim and Mark for your responses.
> .The machine on which SQL Server is running might not have access to my
> machine and my folder.Its on a remote server.
> And I cannot configure that machine so it has access to my machine.
> So I have to install SQL Server locally else I cant accomplish what I am
> trying to do or is there some workaround?
> thanks
>
> "Omnibuzz" wrote:
>
access to
use|||Finally it was decided to download SQL Server express edition 2005 and copy
the Access tables to SQL Server and use for our requirement .
Thanks all for your help.I learnt quite a few things from you all.
Regards,
tech@.77
"Jim Underwood" wrote:

> You can put the MDB on the database server, instead of your PC. Make it a
> share if others need access to it.
> You can put the MDB on a network server that the SQL Server account would
> have access to.
> You can grant the SQL Server account access to the MDB on your machine.
> (the above two require proper network security, but should not be difficul
t)
> You can drop the MDB database entirely and move the tables to SQL Server,
> which is probably the best bet. If you absolutely need to access these
> tables via MS Access, you can create linked tables pointing to SQL Server.
> This will put all the tables local in SQL Server, but still let you use yo
ur
> access front end.
> Is there really a need to have SQL server access your local MDB, rather th
an
> migrating the tables and data to SQL Server?
>
> "tech77" <tech77@.discussions.microsoft.com> wrote in message
> news:7B9F4484-F46C-493F-8830-A5602EC96B55@.microsoft.com...
> access to
> use
>
>