Friday, February 24, 2012

Local Management Studio cannot connect to Remote IS

I am not able to connect my local SQL Server Management Studio to a remote server hosting our Integration Services. I get the infamous "Access Denied". I have walked through Kirk Haselden's howto at:

http://www.sqljunkies.com/WebLog/knight_reign/archive/2006/01/05/17769.aspx

but the problem persists.

Thanks for any help.

Keehan

Well, with the help of MS support this has been figured out. The above web link is very nearly complete. The only part that I was missing that was crucial was to go to Component Services on the local machine, right click on My Computer and go to the Default Properties tab. Make sure that "Enable Distributed COM on this computer" is checked. Once I did this I was able to connect right away. So, the moral of the story, check your local DCOM settings as well as those on the server.

Now, one thing to remember, you can connect using Management Studio, but if you try to execute packages they will fail. To run packages you need to also install SSIS from say the Developers Edition on your local machine. Once these 2 things were fixed, I can connect with Management Studio and execute packages via Management Studio.

With both of these changes I am also able now to kickoff jobs via the local dtexec commandline tool.

Cheers,

Keehan

|||

I have the same problem. And, I reviewed/setting based on those documents. I still got the "Access Denied".

However, if the local user have local admin on remote SSIS server, then user will be able connect to the server.

Any input will be helpful.

James Cheng

|||

I overcome this problem by adding local user to "Distributed DCOM Users' group on SSIS server.

Thanks.

|||

Keehan,

As suggested, I have added myself and others in my group to the Distributed COM group on our web server. I still get the error below. The link below appears bad.I am trying to connect using Windows Authentication, as is is the only method available in the Connect dialog. For the Engine, either Windows or SQL Server Authentication works just fine.


TITLE: Connect to Server

Cannot connect to ded1368dter.maximumasp.com.


ADDITIONAL INFORMATION:

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

Connect to SSIS Service on machine "ded1368dter.maximumasp.com" failed:
The RPC server is unavailable.
.

Connect to SSIS Service on machine "ded1368dter.maximumasp.com" failed:
The RPC server is unavailable.
.


BUTTONS:

OK


|||

I have the same problem. What's different about our setups that we have to jump through all these hoops ? Did everyone else in the world know to add themselves to the DCOM group ? (which didn't seem to help me anyway). What account do people use on the server for the SQL services ? LocalSystem, or a special windows account ?

When I go into Surface Area Configuration, I notice that "Database Engine" and "Analysis Services" have a sub-tab for "Service" and "Remote Connections". However, "Integration Services" only has a sub-tab for Service, not Remote Connections. Is that OK ?

|||FYI Same problems... tried all the setups including manually adding the group... still "access denied" except for people that are admin on the server.|||I believe that the problem was caused by a bad file of some sort on the CD. We were using the MSDN license CDs and everything else seemed to work. Another guy in the dept had his own MSDN CD he got at a trade show, and his worked fine. When his was installed on the other developers machines, they worked fine as well ........ So maybe others have similar bad CDs ?

local ip address

i've got a ms access mdb connected to a sql server on the internet.
whats the quickest way to get the ipaddress on the client machine from
the client machine? since there is a existing connection, shudn't there
be a simple method call that returns the ipaddress on the connection or
something?
the solutions i've seen r very ugly :(
riyazYou can get the MAC address of the client by doing this...
select net_address from master..sysprocesses where spid = @.@.spid
You then need to do processing outside of SQL Server in order to relate the
net_address to an IP address.
Tony.
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials
<rmanchu@.gmail.com> wrote in message
news:1137653314.617807.262180@.g43g2000cwa.googlegroups.com...
> i've got a ms access mdb connected to a sql server on the internet.
> whats the quickest way to get the ipaddress on the client machine from
> the client machine? since there is a existing connection, shudn't there
> be a simple method call that returns the ipaddress on the connection or
> something?
> the solutions i've seen r very ugly :(
> riyaz
>|||yup i'm already getting the mac address like that. but i can't find any
clean function that relates the mac to the ipaddr. the code on the
mvp.org site returns a collection which i don't think can be related to
the mac
how can this be done?
? possible bug?
!!! i noticed the following when using access2003 over the internet to
sqlserver2000 !!!
when using my laptop with wifi, the net_address returned by
sysprocesses is INCORRECT. it returns my LAN mac_address when it shud
return my wifi mac_address since i'm connected the internet thru wifi.
can anybody duplicate this?
riyaz|||>> yup i'm already getting the mac address like that. but i can't find any
All you have to do is to use the address resolution protocol mapping. On
your command prompt, simply type in ARP -a. It should give you a table of
mapping between all MAC & IP addresses.
It is not that hard to get this information from t-SQL ( script or within a
procedure )using master..xp_cmdshell & get the IP address.
Anith|||hi.

> You can get the MAC address of the client by doing this...
> select net_address from master..sysprocesses where spid = @.@.spid
am already doing this

> You then need to do processing outside of SQL Server in order to relate th
e
> net_address to an IP address.
am working in access2003. could u give me an idea as to how i might go
about doing this?
i have 2 ip-addresses both dynamically allocated. i wud prefer a
general solution
riyaz|||I wrote this here just for you:
CREATE PROCEDURE usp_getboundAddresses
AS
BEGIN
SET NOCOUNT ON
IF OBJECT_ID('tempdb..#SomeTable') IS NULL
CREATE TABLE #SomeTable
(
ShellOutput VARCHAR(500)
)
INSERT INTO #SomeTable
EXEC xp_cmdshell 'nbtstat -a .'
SELECT
SUBSTRING( ShellOutput,
CHARINDEX('[',ShellOutput)+1,
LEN(ShellOutput) - CHARINDEX(']',ShellOutput) -2
) AS BoundAddress
from #SomeTable
WHERE ShellOutput LIKE '%Node IpAddress%' --the important lines
AND ShellOutput NOT LIKE '%0.0.0.0%' --Unassigned addresses
DROP TABLE #SomeTable
END
Returning the network adresses of the server.
HTH, Jens Suessmeyer.

Local Intranet mode versus Internet mode.

Hi,

Currently, our Report Builder is running on Local Intranet mode. I'm investigating what the security implications are in changing it to Internet mode. However, I've not been able to find any documentation on this.

Does anyone know of any documentation that addresses this issue or have experience that they can share with changing Report Builder security zone from Intranet mode to Internet mode?

Thanks very much.

Invest in firewalls/routers... both for your users and server at work.

Local instances being used for all linked (remote) instances

I'm getting this bizarre behavior where the local instances are being used i
ntead of the remote instances I'm trying to attach to. For background sake,
I'm running on a Windows 2003 Server that is a Domain controller. The other
SQL instances are on other
systems on another domain.
On the Windows 2003 server that has this problem it can only connect to remo
te instances that have similar names and then it overrides it with its own i
nstance. For example:
2003 server domain D2:
Instance: SRV1 (default, using maching name only)
Other systems on other domain D1:
Instance: SRV2 (default, using maching name only)
SRV2\Test
SRV3
SRV3\Test2
Assume all default instances have same sa password.
In enterprise manager on SRV1 you can register remote default instances and
it seems to connect up to them but when you view the databases you realize i
t connected to the local default instance.
Now if you try to connect up to an remote instance name that isn't on the lo
cal SRV1 system or if the password is different, it can't register it.
Finally if you go on SRV2 or SRV3, there is no conflicts registering instanc
es from the other systems including SRV1.
I tried to remove/reinstall SQL (and all instances) from SRV1, but same thin
g occurred.
Any ideas?Try registring the server using the IP and port number instead of the DNS
name. See if that helps..
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"MJF" <anonymous@.discussions.microsoft.com> wrote in message
news:F7B2A2D9-5304-4B3A-8F39-04C4AB9F390B@.microsoft.com...
> I'm getting this bizarre behavior where the local instances are being used
intead of the remote instances I'm trying to attach to. For background sake,
I'm running on a Windows 2003 Server that is a Domain controller. The other
SQL instances are on other systems on another domain.
> On the Windows 2003 server that has this problem it can only connect to
remote instances that have similar names and then it overrides it with its
own instance. For example:
> 2003 server domain D2:
> Instance: SRV1 (default, using maching name only)
> Other systems on other domain D1:
> Instance: SRV2 (default, using maching name only)
> SRV2\Test
> SRV3
> SRV3\Test2
> Assume all default instances have same sa password.
> In enterprise manager on SRV1 you can register remote default instances
and it seems to connect up to them but when you view the databases you
realize it connected to the local default instance.
> Now if you try to connect up to an remote instance name that isn't on the
local SRV1 system or if the password is different, it can't register it.
> Finally if you go on SRV2 or SRV3, there is no conflicts registering
instances from the other systems including SRV1.
> I tried to remove/reinstall SQL (and all instances) from SRV1, but same
thing occurred.
> Any ideas?
>
>|||Also look at the SQL Client Network Utility on the SRV1 server and see if
there is an alias that points to SRV1. It could be using that alias when
you rgister the other SRV1 servers. If there is one there, remove it and
see what happnes. You should not need an alias on the actual server itself.
Rand
This posting is provided "as is" with no warranties and confers no rights.

Local instance registration on 2005

I just installed the workstation components for SQL 2005 and have opened
Management Studio.
I am trying to register a local instance for testing and am not having any
success. If I select "New" under database engines, I do not have any local
servers to choose from. If I attempt to enter my local computer name for the
server name in New Server Registration properties, it will not connect.
Any idea how to set up a local instance?
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...erver/200603/1
Reading you text I see that you installed the Workstation components and then try to access a local
instance. But the Workstation components doesn't include the database engine...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"cbrichards via droptable.com" <u3288@.uwe> wrote in message news:5da4d493ce717@.uwe...
>I just installed the workstation components for SQL 2005 and have opened
> Management Studio.
> I am trying to register a local instance for testing and am not having any
> success. If I select "New" under database engines, I do not have any local
> servers to choose from. If I attempt to enter my local computer name for the
> server name in New Server Registration properties, it will not connect.
> Any idea how to set up a local instance?
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums...erver/200603/1
|||I have "Database Engine".
In SQL 2K you could register a server as [local].
How is that done in SQL 2005?
Tibor Karaszi wrote:[vbcol=seagreen]
>Reading you text I see that you installed the Workstation components and then try to access a local
>instance. But the Workstation components doesn't include the database engine...
>[quoted text clipped - 5 lines]
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...erver/200603/1
|||cbrichards via droptable.com wrote:
> I have "Database Engine".
> In SQL 2K you could register a server as [local].
> How is that done in SQL 2005?
> Tibor Karaszi wrote:
>
>
Where do you have "Database Engine"? You can check under services if you
have sqlserver service and if it's running. If it's there it should be
running. If it isn't there, you haven't installed the database engine.
Regards
Steen
|||I do have sqlserver service running.
Under registered servers when I right click on [local computer name]\
SQLExpress, then select connect, I get an error saying I cannot connect to
the above instance with "error 26 - Error Locating Server/Instance Specified"
Steen Persson (DK) wrote:
>[quoted text clipped - 11 lines]
>Where do you have "Database Engine"? You can check under services if you
>have sqlserver service and if it's running. If it's there it should be
>running. If it isn't there, you haven't installed the database engine.
>Regards
>Steen
Message posted via http://www.droptable.com
|||cbrichards via droptable.com wrote:
> I do have sqlserver service running.
> Under registered servers when I right click on [local computer name]\
> SQLExpress, then select connect, I get an error saying I cannot connect to
> the above instance with "error 26 - Error Locating Server/Instance Specified"
>
> Steen Persson (DK) wrote:
>
Have you tried to go through the SQL Server Configuartion Manager and/or
SQL server Surface Area Configuatio? Maybe there're something you're
missing to setup/enable.
Regards
Steen

Local instance registration on 2005

I just installed the workstation components for SQL 2005 and have opened
Management Studio.
I am trying to register a local instance for testing and am not having any
success. If I select "New" under database engines, I do not have any local
servers to choose from. If I attempt to enter my local computer name for the
server name in New Server Registration properties, it will not connect.
Any idea how to set up a local instance?
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200603/1Reading you text I see that you installed the Workstation components and the
n try to access a local
instance. But the Workstation components doesn't include the database engine
..
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"cbrichards via droptable.com" <u3288@.uwe> wrote in message news:5da4d493ce717@.uwe...[vbcol
=seagreen]
>I just installed the workstation components for SQL 2005 and have opened
> Management Studio.
> I am trying to register a local instance for testing and am not having any
> success. If I select "New" under database engines, I do not have any local
> servers to choose from. If I attempt to enter my local computer name for t
he
> server name in New Server Registration properties, it will not connect.
> Any idea how to set up a local instance?
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200603/1[/vbcol]|||I have "Database Engine".
In SQL 2K you could register a server as [local].
How is that done in SQL 2005?
Tibor Karaszi wrote:[vbcol=seagreen]
>Reading you text I see that you installed the Workstation components and th
en try to access a local
>instance. But the Workstation components doesn't include the database engin
e...
>
>[quoted text clipped - 5 lines]
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200603/1|||cbrichards via droptable.com wrote:
> I have "Database Engine".
> In SQL 2K you could register a server as [local].
> How is that done in SQL 2005?
> Tibor Karaszi wrote:
>
>
Where do you have "Database Engine"? You can check under services if you
have sqlserver service and if it's running. If it's there it should be
running. If it isn't there, you haven't installed the database engine.
Regards
Steen|||I do have sqlserver service running.
Under registered servers when I right click on [local computer name]\
SQLExpress, then select connect, I get an error saying I cannot connect to
the above instance with "error 26 - Error Locating Server/Instance Specified
"
Steen Persson (DK) wrote:
>[quoted text clipped - 11 lines]
>Where do you have "Database Engine"? You can check under services if you
>have sqlserver service and if it's running. If it's there it should be
>running. If it isn't there, you haven't installed the database engine.
>Regards
>Steen
Message posted via http://www.droptable.com|||cbrichards via droptable.com wrote:
> I do have sqlserver service running.
> Under registered servers when I right click on [local computer name]\
> SQLExpress, then select connect, I get an error saying I cannot connect to
> the above instance with "error 26 - Error Locating Server/Instance Specifi
ed"
>
> Steen Persson (DK) wrote:
>
Have you tried to go through the SQL Server Configuartion Manager and/or
SQL server Surface Area Configuatio? Maybe there're something you're
missing to setup/enable.
Regards
Steen

Local instance registration on 2005

I just installed the workstation components for SQL 2005 and have opened
Management Studio.
I am trying to register a local instance for testing and am not having any
success. If I select "New" under database engines, I do not have any local
servers to choose from. If I attempt to enter my local computer name for the
server name in New Server Registration properties, it will not connect.
Any idea how to set up a local instance?
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200603/1Reading you text I see that you installed the Workstation components and then try to access a local
instance. But the Workstation components doesn't include the database engine...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"cbrichards via SQLMonster.com" <u3288@.uwe> wrote in message news:5da4d493ce717@.uwe...
>I just installed the workstation components for SQL 2005 and have opened
> Management Studio.
> I am trying to register a local instance for testing and am not having any
> success. If I select "New" under database engines, I do not have any local
> servers to choose from. If I attempt to enter my local computer name for the
> server name in New Server Registration properties, it will not connect.
> Any idea how to set up a local instance?
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200603/1|||I have "Database Engine".
In SQL 2K you could register a server as [local].
How is that done in SQL 2005?
Tibor Karaszi wrote:
>Reading you text I see that you installed the Workstation components and then try to access a local
>instance. But the Workstation components doesn't include the database engine...
>>I just installed the workstation components for SQL 2005 and have opened
>> Management Studio.
>[quoted text clipped - 5 lines]
>> Any idea how to set up a local instance?
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200603/1|||cbrichards via SQLMonster.com wrote:
> I have "Database Engine".
> In SQL 2K you could register a server as [local].
> How is that done in SQL 2005?
> Tibor Karaszi wrote:
>>Reading you text I see that you installed the Workstation components and then try to access a local
>>instance. But the Workstation components doesn't include the database engine...
>>
>>I just installed the workstation components for SQL 2005 and have opened
>>Management Studio.
>>[quoted text clipped - 5 lines]
>>Any idea how to set up a local instance?
>
Where do you have "Database Engine"? You can check under services if you
have sqlserver service and if it's running. If it's there it should be
running. If it isn't there, you haven't installed the database engine.
Regards
Steen|||I do have sqlserver service running.
Under registered servers when I right click on [local computer name]\
SQLExpress, then select connect, I get an error saying I cannot connect to
the above instance with "error 26 - Error Locating Server/Instance Specified"
Steen Persson (DK) wrote:
>> I have "Database Engine".
>[quoted text clipped - 11 lines]
>>Any idea how to set up a local instance?
>Where do you have "Database Engine"? You can check under services if you
>have sqlserver service and if it's running. If it's there it should be
>running. If it isn't there, you haven't installed the database engine.
>Regards
>Steen
--
Message posted via http://www.sqlmonster.com|||cbrichards via SQLMonster.com wrote:
> I do have sqlserver service running.
> Under registered servers when I right click on [local computer name]\
> SQLExpress, then select connect, I get an error saying I cannot connect to
> the above instance with "error 26 - Error Locating Server/Instance Specified"
>
> Steen Persson (DK) wrote:
>
Have you tried to go through the SQL Server Configuartion Manager and/or
SQL server Surface Area Configuatio? Maybe there're something you're
missing to setup/enable.
Regards
Steen

Local Groups and Access.

I'm trying to prototype some reports, and having difficulties granting access
to users, connecting to my LocalHost.
I work for a company that uses LDAP.
I have RS running on my LocalHost, and would like to grant access to users
to Report Manager so they can render reports.
In the Computer management > Local Users & Groups > Groups: I see Users,
Guests. Can I add these group(s) in the Report Manager using 'New Role
Assignment', and assign a Role, like Browser, then will a unknown user be
able to visit the site and render some reports.
Thanks,
rwiethornI'm getting closer, the user can see the reportmanger but cannot run a report.
Here is what I did:
I created a user on my local machine, call him Bob. I then created a group
on my local machine, called ReportViewers, and added Bob to the group. I then
added the group to ReportManager, gave it a Content Manager role, and for
'Configure site-wide security', System Role Assignments, assigned the group
as System Users.
However, they can not view the report. Ther error points to the Datasource.
The Datasource is supposed to pull a recordset from the AdventureWorks
catalog. It uses the SA account. When I look at the datasource in the
ReportManager, the credentials are saved (user name: sa and its password).
So why would that not return the results from the AdventureWorks database?
Do I neeed to add the local group also to the Database and catalog?
Do I need to add the IUSR_machine account to the database?
Do I need to add the ASPNET account to the group?
All help is appreciated,
thanks, confused,
rwiethorn
"rwiethorn" wrote:
> I'm trying to prototype some reports, and having difficulties granting access
> to users, connecting to my LocalHost.
> I work for a company that uses LDAP.
> I have RS running on my LocalHost, and would like to grant access to users
> to Report Manager so they can render reports.
> In the Computer management > Local Users & Groups > Groups: I see Users,
> Guests. Can I add these group(s) in the Report Manager using 'New Role
> Assignment', and assign a Role, like Browser, then will a unknown user be
> able to visit the site and render some reports.
> Thanks,
> rwiethorn

Local group permissions

Hi,
Is it possible to grant role assignment to report server local groups in
SSRS 2000? if so, how? I can't do it.
Thanks
AlexI managed to set local group policy only by adding the users to a
server-level group and then assign that group permissions. The same can be
done by adding individual accounts to the server itself, but I was unable to
create groups within RS itself.
Hope this assists,
"Alex" wrote:
> Hi,
> Is it possible to grant role assignment to report server local groups in
> SSRS 2000? if so, how? I can't do it.
> Thanks
> Alex
>
>|||Is is possible to restrict group rights per report using domain groups.
If I want a particular user to be able to view one or two reports and those
alone without viewing other reports, how would I attempt this. Say I want
only Sales see the sales reports, payroll to see only payroll, Tech Support
to see Tech Support and etc...
is this possible?
Regards,
Samson
"Logicalman" wrote:
> I managed to set local group policy only by adding the users to a
> server-level group and then assign that group permissions. The same can be
> done by adding individual accounts to the server itself, but I was unable to
> create groups within RS itself.
> Hope this assists,
> "Alex" wrote:
> > Hi,
> >
> > Is it possible to grant role assignment to report server local groups in
> > SSRS 2000? if so, how? I can't do it.
> >
> > Thanks
> > Alex
> >
> >
> >|||Samson,
Yes, you simply add the user to the group having permission on that report.
Be aware though, that by adding the user to that group he/she will then be
able to view ALL reports that particular group has permissions to.
example.
Report 1
Report 2
Report 3
Report 4
Group A
Group B
If Group A is given permission to browse Reports 1 and 2, and Group B is
given permission to view Reports 2,3 and 4.
By adding User X to Broup A, he/she will have access to Reports 1 and 2, by
adding User z to Group B he/she will have access to Reports 2,3 and 4.
If you want User Y to view Report 2 only, and no other Reports, then you
will need to either add that user directly to Report 2, or create a new Group
C, and assign permissions to Group C to view Report 2.
Again, such Gropus may be part of the Active Directory or the Server.
I hope this clears up any ambiguity.
"Samson" wrote:
> Is is possible to restrict group rights per report using domain groups.
> If I want a particular user to be able to view one or two reports and those
> alone without viewing other reports, how would I attempt this. Say I want
> only Sales see the sales reports, payroll to see only payroll, Tech Support
> to see Tech Support and etc...
> is this possible?
>
> --
> Regards,
> Samson
>
> "Logicalman" wrote:
> > I managed to set local group policy only by adding the users to a
> > server-level group and then assign that group permissions. The same can be
> > done by adding individual accounts to the server itself, but I was unable to
> > create groups within RS itself.
> >
> > Hope this assists,
> >
> > "Alex" wrote:
> >
> > > Hi,
> > >
> > > Is it possible to grant role assignment to report server local groups in
> > > SSRS 2000? if so, how? I can't do it.
> > >
> > > Thanks
> > > Alex
> > >
> > >
> > >|||That is good news. I guess my question is how. I created 3 users groups,
sales, techs, payroll.
How do I set the permission on the particular folder that holds the reports?
Regards,
Samson
"Logicalman" wrote:
> Samson,
> Yes, you simply add the user to the group having permission on that report.
> Be aware though, that by adding the user to that group he/she will then be
> able to view ALL reports that particular group has permissions to.
> example.
> Report 1
> Report 2
> Report 3
> Report 4
> Group A
> Group B
> If Group A is given permission to browse Reports 1 and 2, and Group B is
> given permission to view Reports 2,3 and 4.
> By adding User X to Broup A, he/she will have access to Reports 1 and 2, by
> adding User z to Group B he/she will have access to Reports 2,3 and 4.
> If you want User Y to view Report 2 only, and no other Reports, then you
> will need to either add that user directly to Report 2, or create a new Group
> C, and assign permissions to Group C to view Report 2.
> Again, such Gropus may be part of the Active Directory or the Server.
> I hope this clears up any ambiguity.
>
> "Samson" wrote:
> > Is is possible to restrict group rights per report using domain groups.
> >
> > If I want a particular user to be able to view one or two reports and those
> > alone without viewing other reports, how would I attempt this. Say I want
> > only Sales see the sales reports, payroll to see only payroll, Tech Support
> > to see Tech Support and etc...
> >
> > is this possible?
> >
> >
> > --
> > Regards,
> >
> > Samson
> >
> >
> > "Logicalman" wrote:
> >
> > > I managed to set local group policy only by adding the users to a
> > > server-level group and then assign that group permissions. The same can be
> > > done by adding individual accounts to the server itself, but I was unable to
> > > create groups within RS itself.
> > >
> > > Hope this assists,
> > >
> > > "Alex" wrote:
> > >
> > > > Hi,
> > > >
> > > > Is it possible to grant role assignment to report server local groups in
> > > > SSRS 2000? if so, how? I can't do it.
> > > >
> > > > Thanks
> > > > Alex
> > > >
> > > >
> > > >|||I think after reading youtr post again I can set the permission within the
report as well. I think I understand now.
Regards,
Samson
"Samson" wrote:
> That is good news. I guess my question is how. I created 3 users groups,
> sales, techs, payroll.
> How do I set the permission on the particular folder that holds the reports?
>
> --
> Regards,
> Samson
>
> "Logicalman" wrote:
> > Samson,
> >
> > Yes, you simply add the user to the group having permission on that report.
> > Be aware though, that by adding the user to that group he/she will then be
> > able to view ALL reports that particular group has permissions to.
> > example.
> > Report 1
> > Report 2
> > Report 3
> > Report 4
> >
> > Group A
> > Group B
> >
> > If Group A is given permission to browse Reports 1 and 2, and Group B is
> > given permission to view Reports 2,3 and 4.
> > By adding User X to Broup A, he/she will have access to Reports 1 and 2, by
> > adding User z to Group B he/she will have access to Reports 2,3 and 4.
> >
> > If you want User Y to view Report 2 only, and no other Reports, then you
> > will need to either add that user directly to Report 2, or create a new Group
> > C, and assign permissions to Group C to view Report 2.
> > Again, such Gropus may be part of the Active Directory or the Server.
> >
> > I hope this clears up any ambiguity.
> >
> >
> > "Samson" wrote:
> >
> > > Is is possible to restrict group rights per report using domain groups.
> > >
> > > If I want a particular user to be able to view one or two reports and those
> > > alone without viewing other reports, how would I attempt this. Say I want
> > > only Sales see the sales reports, payroll to see only payroll, Tech Support
> > > to see Tech Support and etc...
> > >
> > > is this possible?
> > >
> > >
> > > --
> > > Regards,
> > >
> > > Samson
> > >
> > >
> > > "Logicalman" wrote:
> > >
> > > > I managed to set local group policy only by adding the users to a
> > > > server-level group and then assign that group permissions. The same can be
> > > > done by adding individual accounts to the server itself, but I was unable to
> > > > create groups within RS itself.
> > > >
> > > > Hope this assists,
> > > >
> > > > "Alex" wrote:
> > > >
> > > > > Hi,
> > > > >
> > > > > Is it possible to grant role assignment to report server local groups in
> > > > > SSRS 2000? if so, how? I can't do it.
> > > > >
> > > > > Thanks
> > > > > Alex
> > > > >
> > > > >
> > > > >

Local drive doesn't appear more !

Hi,
I have a SQL Server 7.0 (SP4) with 1 phisical disk drive and 3 logical
partitions (C, D, E). This happened unexpectedly when I was deleting a
database.
I can see normally the letter E in windows explorer, but it doesn't appear
and permit me more create a database em that letter.
Any idea ?
Regards,
Vitor Mauricio
Check file permissions to ensure the SQL Server service account has full
permissions to the root folder.
Hope this helps.
Dan Guzman
SQL Server MVP
"Vitor Mauricio de N. Silva" <vitor_mauricio@.hotmail.com> wrote in message
news:e4yjo36ZEHA.3112@.tk2msftngp13.phx.gbl...
> Hi,
> I have a SQL Server 7.0 (SP4) with 1 phisical disk drive and 3 logical
> partitions (C, D, E). This happened unexpectedly when I was deleting a
> database.
> I can see normally the letter E in windows explorer, but it doesn't appear
> and permit me more create a database em that letter.
> Any idea ?
> Regards,
> Vitor Mauricio
>
|||Vitor,
Adding to Dan's post, deleting a database would not have done anything
to your partitions, or your file system security settings. This would
have been a separate operation.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Dan Guzman wrote:
> Check file permissions to ensure the SQL Server service account has full
> permissions to the root folder.
>
|||Check event viewer for any information on this behaviour.
--
Satya SKJ
"Vitor Mauricio de N. Silva" wrote:

> Hi,
> I have a SQL Server 7.0 (SP4) with 1 phisical disk drive and 3 logical
> partitions (C, D, E). This happened unexpectedly when I was deleting a
> database.
> I can see normally the letter E in windows explorer, but it doesn't appear
> and permit me more create a database em that letter.
> Any idea ?
> Regards,
> Vitor Mauricio
>
>
|||All,
I check the file permission and everything is ok. In the event viewer I
cant see any error.
I never see this before, but the problems continue.
Thanks in advance for any suggestions,
Vitor Mauricio
"Vitor Mauricio de N. Silva" <vitor_mauricio@.hotmail.com> wrote in message
news:e4yjo36ZEHA.3112@.tk2msftngp13.phx.gbl...
> Hi,
> I have a SQL Server 7.0 (SP4) with 1 phisical disk drive and 3 logical
> partitions (C, D, E). This happened unexpectedly when I was deleting a
> database.
> I can see normally the letter E in windows explorer, but it doesn't appear
> and permit me more create a database em that letter.
> Any idea ?
> Regards,
> Vitor Mauricio
>

Local drive doesn't appear more !

Hi,
I have a SQL Server 7.0 (SP4) with 1 phisical disk drive and 3 logical
partitions (C, D, E). This happened unexpectedly when I was deleting a
database.
I can see normally the letter E in windows explorer, but it doesn't appear
and permit me more create a database em that letter.
Any idea ?
Regards,
Vitor MauricioCheck file permissions to ensure the SQL Server service account has full
permissions to the root folder.
Hope this helps.
Dan Guzman
SQL Server MVP
"Vitor Mauricio de N. Silva" <vitor_mauricio@.hotmail.com> wrote in message
news:e4yjo36ZEHA.3112@.tk2msftngp13.phx.gbl...
> Hi,
> I have a SQL Server 7.0 (SP4) with 1 phisical disk drive and 3 logical
> partitions (C, D, E). This happened unexpectedly when I was deleting a
> database.
> I can see normally the letter E in windows explorer, but it doesn't appear
> and permit me more create a database em that letter.
> Any idea ?
> Regards,
> Vitor Mauricio
>|||Vitor,
Adding to Dan's post, deleting a database would not have done anything
to your partitions, or your file system security settings. This would
have been a separate operation.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Dan Guzman wrote:
> Check file permissions to ensure the SQL Server service account has full
> permissions to the root folder.
>|||Check event viewer for any information on this behaviour.
--
--
Satya SKJ
"Vitor Mauricio de N. Silva" wrote:

> Hi,
> I have a SQL Server 7.0 (SP4) with 1 phisical disk drive and 3 logical
> partitions (C, D, E). This happened unexpectedly when I was deleting a
> database.
> I can see normally the letter E in windows explorer, but it doesn't appear
> and permit me more create a database em that letter.
> Any idea ?
> Regards,
> Vitor Mauricio
>
>|||All,
I check the file permission and everything is ok. In the event viewer I
cant see any error.
I never see this before, but the problems continue.
Thanks in advance for any suggestions,
Vitor Mauricio
"Vitor Mauricio de N. Silva" <vitor_mauricio@.hotmail.com> wrote in message
news:e4yjo36ZEHA.3112@.tk2msftngp13.phx.gbl...
> Hi,
> I have a SQL Server 7.0 (SP4) with 1 phisical disk drive and 3 logical
> partitions (C, D, E). This happened unexpectedly when I was deleting a
> database.
> I can see normally the letter E in windows explorer, but it doesn't appear
> and permit me more create a database em that letter.
> Any idea ?
> Regards,
> Vitor Mauricio
>

Local drive doesn't appear more !

Hi,
I have a SQL Server 7.0 (SP4) with 1 phisical disk drive and 3 logical
partitions (C, D, E). This happened unexpectedly when I was deleting a
database.
I can see normally the letter E in windows explorer, but it doesn't appear
and permit me more create a database em that letter.
Any idea ?
Regards,
Vitor MauricioCheck file permissions to ensure the SQL Server service account has full
permissions to the root folder.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Vitor Mauricio de N. Silva" <vitor_mauricio@.hotmail.com> wrote in message
news:e4yjo36ZEHA.3112@.tk2msftngp13.phx.gbl...
> Hi,
> I have a SQL Server 7.0 (SP4) with 1 phisical disk drive and 3 logical
> partitions (C, D, E). This happened unexpectedly when I was deleting a
> database.
> I can see normally the letter E in windows explorer, but it doesn't appear
> and permit me more create a database em that letter.
> Any idea ?
> Regards,
> Vitor Mauricio
>|||Vitor,
Adding to Dan's post, deleting a database would not have done anything
to your partitions, or your file system security settings. This would
have been a separate operation.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Dan Guzman wrote:
> Check file permissions to ensure the SQL Server service account has full
> permissions to the root folder.
>|||All,
I check the file permission and everything is ok. In the event viewer I
can´t see any error.
I never see this before, but the problems continue.
Thanks in advance for any suggestions,
Vitor Mauricio
"Vitor Mauricio de N. Silva" <vitor_mauricio@.hotmail.com> wrote in message
news:e4yjo36ZEHA.3112@.tk2msftngp13.phx.gbl...
> Hi,
> I have a SQL Server 7.0 (SP4) with 1 phisical disk drive and 3 logical
> partitions (C, D, E). This happened unexpectedly when I was deleting a
> database.
> I can see normally the letter E in windows explorer, but it doesn't appear
> and permit me more create a database em that letter.
> Any idea ?
> Regards,
> Vitor Mauricio
>

Local Drillthrough Report 'Data source Instance has not been supplied'

I've searched and searched and can't find how to do this.
I've got a main report and a report that I am trying to use the 'Jump
to' ability with. I am capturing the ReportViewer1.DrillThrough event
and am doing this:
ReportViewer1.LocalReport.DataSources.Add(New
ReportDataSource("JobApplications_ApplicantDetails",
LoadApplicantDetailsData()))
I have set this report as the 'main' report that runs in the viewer
when it first loads and it works correctly but just not when 'jumped
to'. I have removed all parameters that need to be passed to the
report so there is nothing missing there.
This is the actual error I recieve:
A data source instance has not been supplied for the data source
'JobApplications_ApplicantDetails'.
Any help is greatly appreciated.
ThanksDo you still have these problems by viewing a new report in the same
reportviewer control after you activate a "jump to report" in the original
report (Me too...)
I will try to experiment more with it this evening.
Do somebody already have an answer
--
Regards
dagha
"hurst.andy@.gmail.com" wrote:
> I've searched and searched and can't find how to do this.
> I've got a main report and a report that I am trying to use the 'Jump
> to' ability with. I am capturing the ReportViewer1.DrillThrough event
> and am doing this:
> ReportViewer1.LocalReport.DataSources.Add(New
> ReportDataSource("JobApplications_ApplicantDetails",
> LoadApplicantDetailsData()))
> I have set this report as the 'main' report that runs in the viewer
> when it first loads and it works correctly but just not when 'jumped
> to'. I have removed all parameters that need to be passed to the
> report so there is nothing missing there.
> This is the actual error I recieve:
> A data source instance has not been supplied for the data source
> 'JobApplications_ApplicantDetails'.
> Any help is greatly appreciated.
> Thanks
>|||Hi I am getting the following error message when using drillthrough and
jump to another report in the same reportviewer.
Error message:
A Datasource instance has not been supplied for the data source
'DataSetProductDetail_ShowProductByProductID'
--
MyCode:
Protected Sub DemoDrillthroughEventHandler(ByVal sender As Object,
ByVal e As DrillthroughEventArgs) Handles ReportViewer1.Drillthrough
Dim drillthroughReport As LocalReport = CType(e.Report, LocalReport)
Dim MydataSet As DataSet = New DataSet()
Dim thisConnection As SqlConnection = New
SqlConnection(ConfigurationManager.ConnectionStrings("NorthwindConnectionString").ConnectionString)
Dim myCommandDataAdapter As SqlDataAdapter = New
SqlDataAdapter("DataSetProductDetail_ShowProductByProductID",
thisConnection)
myCommandDataAdapter.SelectCommand.CommandType =CommandType.StoredProcedure
myCommandDataAdapter.SelectCommand.CommandText ="ShowProductByProductID"
myCommandDataAdapter.SelectCommand.Parameters.Add(New
SqlParameter("@.ProductID", 2))
myCommandDataAdapter.Fill(MydataSet,
"DataSetProductDetail_ShowProductByProductID")
'Associate thisDataSet(now loaded with the stored procedure
result)
'with the ReportViewer datasource
Dim datasource1 As ReportDataSource = New
ReportDataSource("DataSetProductDetail_ShowProductByProductID",
Mydataset.Tables(0))
ReportViewer1.LocalReport.DataSources.Clear()
ReportViewer1.LocalReport.DataSources.Add(datasource1)
ReportViewer1.LocalReport.Refresh()
End Sub
--
Any ideas?
dagha wrote:
> Do you still have these problems by viewing a new report in the same
> reportviewer control after you activate a "jump to report" in the original
> report (Me too...)
> I will try to experiment more with it this evening.
> Do somebody already have an answer
> --
> Regards
> dagha
>
> "hurst.andy@.gmail.com" wrote:
> > I've searched and searched and can't find how to do this.
> >
> > I've got a main report and a report that I am trying to use the 'Jump
> > to' ability with. I am capturing the ReportViewer1.DrillThrough event
> > and am doing this:
> >
> > ReportViewer1.LocalReport.DataSources.Add(New
> > ReportDataSource("JobApplications_ApplicantDetails",
> > LoadApplicantDetailsData()))
> >
> > I have set this report as the 'main' report that runs in the viewer
> > when it first loads and it works correctly but just not when 'jumped
> > to'. I have removed all parameters that need to be passed to the
> > report so there is nothing missing there.
> >
> > This is the actual error I recieve:
> > A data source instance has not been supplied for the data source
> > 'JobApplications_ApplicantDetails'.
> >
> > Any help is greatly appreciated.
> > Thanks
> >
> >

Local DB's refuse to start

Last week my local DB's got hosed, so over the weekend, I reinstalled them
(2000 & 2005). However, I was away and connected to a different network (IP
change) when I reinstalled the servers (yes, I know it was screwy, but thats
what I did).
Now, back at work, everythin is fine remotly, however, my local instances of
SQL Server refuse to start, the message is:
The service did not start due to a logon failure.
-and-
An error 1069 - (The service did not start due to a logon failure.)
occured while performing this service operation on the MSSQLServer service.
I use the same DOMAIN\Login whether connected internally, or not.
--
Am I going to have to reinstall while connected to the domain?
Thanks,
JayCheck if the user account that runs the SQL Server service has a changed
password or an expired password.
Linchi
"Jay" wrote:
> Last week my local DB's got hosed, so over the weekend, I reinstalled them
> (2000 & 2005). However, I was away and connected to a different network (IP
> change) when I reinstalled the servers (yes, I know it was screwy, but thats
> what I did).
> Now, back at work, everythin is fine remotly, however, my local instances of
> SQL Server refuse to start, the message is:
> The service did not start due to a logon failure.
> -and-
> An error 1069 - (The service did not start due to a logon failure.)
> occured while performing this service operation on the MSSQLServer service.
>
> I use the same DOMAIN\Login whether connected internally, or not.
> --
> Am I going to have to reinstall while connected to the domain?
> Thanks,
> Jay
>
>|||Nope, I installed the servers under my domain account.
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:B53CBAAC-1C38-450D-8623-61CC7BA9273A@.microsoft.com...
> Check if the user account that runs the SQL Server service has a changed
> password or an expired password.
> Linchi
> "Jay" wrote:
>> Last week my local DB's got hosed, so over the weekend, I reinstalled
>> them
>> (2000 & 2005). However, I was away and connected to a different network
>> (IP
>> change) when I reinstalled the servers (yes, I know it was screwy, but
>> thats
>> what I did).
>> Now, back at work, everythin is fine remotly, however, my local instances
>> of
>> SQL Server refuse to start, the message is:
>> The service did not start due to a logon failure.
>> -and-
>> An error 1069 - (The service did not start due to a logon failure.)
>> occured while performing this service operation on the MSSQLServer
>> service.
>>
>> I use the same DOMAIN\Login whether connected internally, or not.
>> --
>> Am I going to have to reinstall while connected to the domain?
>> Thanks,
>> Jay
>>|||Just because the error message says so, I'd still go to the services.msc, and
re-enter the password for the service account. Until you try, you can't be
sure.
Linchi
"Jay" wrote:
> Nope, I installed the servers under my domain account.
> "Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
> news:B53CBAAC-1C38-450D-8623-61CC7BA9273A@.microsoft.com...
> > Check if the user account that runs the SQL Server service has a changed
> > password or an expired password.
> >
> > Linchi
> >
> > "Jay" wrote:
> >
> >> Last week my local DB's got hosed, so over the weekend, I reinstalled
> >> them
> >> (2000 & 2005). However, I was away and connected to a different network
> >> (IP
> >> change) when I reinstalled the servers (yes, I know it was screwy, but
> >> thats
> >> what I did).
> >>
> >> Now, back at work, everythin is fine remotly, however, my local instances
> >> of
> >> SQL Server refuse to start, the message is:
> >>
> >> The service did not start due to a logon failure.
> >>
> >> -and-
> >>
> >> An error 1069 - (The service did not start due to a logon failure.)
> >> occured while performing this service operation on the MSSQLServer
> >> service.
> >>
> >>
> >> I use the same DOMAIN\Login whether connected internally, or not.
> >>
> >> --
> >>
> >> Am I going to have to reinstall while connected to the domain?
> >>
> >> Thanks,
> >> Jay
> >>
> >>
> >>
>
>|||That worked, though why is a mystery to me. I was not completely aware that
the Windows services contained the login/password, I expected it in SQL
Server itself. Kinda silly of me I know, but I just never thought it through
properly.
Thanks,
Jay
PS. It took me a bit to get to it as there have been several things going
on.
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:66452707-C62C-42E3-981E-BBEDC3CA6D4D@.microsoft.com...
> Just because the error message says so, I'd still go to the services.msc,
> and
> re-enter the password for the service account. Until you try, you can't be
> sure.
> Linchi
> "Jay" wrote:
>> Nope, I installed the servers under my domain account.
>> "Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
>> news:B53CBAAC-1C38-450D-8623-61CC7BA9273A@.microsoft.com...
>> > Check if the user account that runs the SQL Server service has a
>> > changed
>> > password or an expired password.
>> >
>> > Linchi
>> >
>> > "Jay" wrote:
>> >
>> >> Last week my local DB's got hosed, so over the weekend, I reinstalled
>> >> them
>> >> (2000 & 2005). However, I was away and connected to a different
>> >> network
>> >> (IP
>> >> change) when I reinstalled the servers (yes, I know it was screwy, but
>> >> thats
>> >> what I did).
>> >>
>> >> Now, back at work, everythin is fine remotly, however, my local
>> >> instances
>> >> of
>> >> SQL Server refuse to start, the message is:
>> >>
>> >> The service did not start due to a logon failure.
>> >>
>> >> -and-
>> >>
>> >> An error 1069 - (The service did not start due to a logon
>> >> failure.)
>> >> occured while performing this service operation on the MSSQLServer
>> >> service.
>> >>
>> >>
>> >> I use the same DOMAIN\Login whether connected internally, or not.
>> >>
>> >> --
>> >>
>> >> Am I going to have to reinstall while connected to the domain?
>> >>
>> >> Thanks,
>> >> Jay
>> >>
>> >>
>> >>
>>|||OK, I now have the problem again.
I was, however, able to trace the problem to the following command being run
(which updates domain policies?)
gpupdate /force
Am I going to have to deal with the network/AD guys, or can I just get the
servers to run by myself?
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:66452707-C62C-42E3-981E-BBEDC3CA6D4D@.microsoft.com...
> Just because the error message says so, I'd still go to the services.msc,
> and
> re-enter the password for the service account. Until you try, you can't be
> sure.
> Linchi
> "Jay" wrote:
>> Nope, I installed the servers under my domain account.
>> "Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
>> news:B53CBAAC-1C38-450D-8623-61CC7BA9273A@.microsoft.com...
>> > Check if the user account that runs the SQL Server service has a
>> > changed
>> > password or an expired password.
>> >
>> > Linchi
>> >
>> > "Jay" wrote:
>> >
>> >> Last week my local DB's got hosed, so over the weekend, I reinstalled
>> >> them
>> >> (2000 & 2005). However, I was away and connected to a different
>> >> network
>> >> (IP
>> >> change) when I reinstalled the servers (yes, I know it was screwy, but
>> >> thats
>> >> what I did).
>> >>
>> >> Now, back at work, everythin is fine remotly, however, my local
>> >> instances
>> >> of
>> >> SQL Server refuse to start, the message is:
>> >>
>> >> The service did not start due to a logon failure.
>> >>
>> >> -and-
>> >>
>> >> An error 1069 - (The service did not start due to a logon
>> >> failure.)
>> >> occured while performing this service operation on the MSSQLServer
>> >> service.
>> >>
>> >>
>> >> I use the same DOMAIN\Login whether connected internally, or not.
>> >>
>> >> --
>> >>
>> >> Am I going to have to reinstall while connected to the domain?
>> >>
>> >> Thanks,
>> >> Jay
>> >>
>> >>
>> >>
>>|||Problem resolved.
I changed the services entry for my instances of SQL Server to use the
"Local System Account" and now, changes in the domain policy no longer
affect my local servers from starting (and having to open services and
retype my password all the time).
Hope this is useful to someone.
"Jay" <nospan@.nospam.org> wrote in message
news:%23FfJDNoGIHA.4272@.TK2MSFTNGP06.phx.gbl...
> Last week my local DB's got hosed, so over the weekend, I reinstalled them
> (2000 & 2005). However, I was away and connected to a different network
> (IP change) when I reinstalled the servers (yes, I know it was screwy, but
> thats what I did).
> Now, back at work, everythin is fine remotly, however, my local instances
> of SQL Server refuse to start, the message is:
> The service did not start due to a logon failure.
> -and-
> An error 1069 - (The service did not start due to a logon failure.)
> occured while performing this service operation on the MSSQLServer
> service.
>
> I use the same DOMAIN\Login whether connected internally, or not.
> --
> Am I going to have to reinstall while connected to the domain?
> Thanks,
> Jay
>

Local DB Affected By VPN

I work on a local copy of a database (Access 2000 MDB with ODBC linked
tables to a SQL 7 database). The SQL Server db I'm working with is on my C
drive (MSDE). Occasionally I'll connect to a VPN to do something on a remote
computer, using PC Anywhere to perform the task. Doesn't involve my front or
back end at all, except that the computer I'm VPNing to has a SQL database
running.
OK, so I'm using my db; I connect to the VPN, and do my thing. Everything's
fine. However, if I then disconnect from the VPN (or if the VPN connection
times out and disconnects itself), I then can no longer access my local SQL
Server database. My Access application still works fine, as long as it
doesn't have to look at any data. When it does have to look at data, I get
ODBC call failed. I have to close and reopen my Access database, and then
everything is fine.
So, it seems that, for some reason, when I connect to the VPN, my local SQL
Server or the ODBC driver or something in the mix is looking at that remote
database as part of what I'm using. Then, when the VPN connection is closed,
it won't access my local database for some reason.
Oh, and my local database and the remote database both have the same name.
So that may be part of the problem.
Any ideas as to what's going on?
Thanks!
Neil
On 26 Nov, 10:15, "Neil" <nos...@.nospam.net> wrote:
> I work on a local copy of a database (Access 2000 MDB with ODBC linked
> tables to a SQL 7 database). The SQL Server db I'm working with is on my C
> drive (MSDE). Occasionally I'll connect to a VPN to do something on a remote
> computer, using PC Anywhere to perform the task. Doesn't involve my front or
> back end at all, except that the computer I'm VPNing to has a SQL database
> running.
> OK, so I'm using my db; I connect to the VPN, and do my thing. Everything's
> fine. However, if I then disconnect from the VPN (or if the VPN connection
> times out and disconnects itself), I then can no longer access my local SQL
> Server database. My Access application still works fine, as long as it
> doesn't have to look at any data. When it does have to look at data, I get
> ODBC call failed. I have to close and reopen my Access database, and then
> everything is fine.
> So, it seems that, for some reason, when I connect to the VPN, my local SQL
> Server or the ODBC driver or something in the mix is looking at that remote
> database as part of what I'm using. Then, when the VPN connection is closed,
> it won't access my local database for some reason.
> Oh, and my local database and the remote database both have the same name.
> So that may be part of the problem.
> Any ideas as to what's going on?
> Thanks!
> Neil
It's only a guess but have you got the means of using Remote Desktop
Terminal Services Client or MSN Messenger Remote Assistance (As a
test) instead of PCAnywhere? I worked on the Laplink support line many
years ago and can imagine that this might be the issue and rings some
bells but things have changed since.
All the best,
Martin
|||On 27 Nov, 13:46, theintrepidfox <theintrepid...@.hotmail.com> wrote:
> On 26 Nov, 10:15, "Neil" <nos...@.nospam.net> wrote:
>
>
>
>
>
>
> It's only a guess but have you got the means of using Remote Desktop
> Terminal Services Client or MSN Messenger Remote Assistance (As a
> test) instead of PCAnywhere? I worked on the Laplink support line many
> years ago and can imagine that this might be the issue and rings some
> bells but things have changed since.
> All the best,
> Martin- Hide quoted text -
> - Show quoted text -
The reason why I'm suggestin it is because PCAnywhere is perhaps
trying to synchromize files between the client and host (including
your .mdb) which is maybe still and remains in use by the Sync Process
when the VPN times out or disconnects.
|||Actually, it usually happens after PCAnywhere has been closed. While
PCAnywhere is open, the VPN connection stays active. After I close
PCAnywhere, if I don't disconnect from the VPN, then eventually the VPN
connection times out.
So, a typical scenario is: open Access app connected to local SQL Server;
later, connect to VPN and do stuff via PCAnywhere; close PCAnywhere; later,
VPN connection disconnects, and then connection to local SQL Server fails.
Have to close and reopen MDB for it to work.
Strange...
"theintrepidfox" <theintrepidfox@.hotmail.com> wrote in message
news:3e278590-302d-4549-82d4-2e12c0b51b1a@.i29g2000prf.googlegroups.com...
> On 26 Nov, 10:15, "Neil" <nos...@.nospam.net> wrote:
> It's only a guess but have you got the means of using Remote Desktop
> Terminal Services Client or MSN Messenger Remote Assistance (As a
> test) instead of PCAnywhere? I worked on the Laplink support line many
> years ago and can imagine that this might be the issue and rings some
> bells but things have changed since.
> All the best,
> Martin
|||"theintrepidfox" <theintrepidfox@.hotmail.com> wrote in message
news:9cb60b5b-5160-4afe-8555-8ed2bed12b09@.s36g2000prg.googlegroups.com...
> On 27 Nov, 13:46, theintrepidfox <theintrepid...@.hotmail.com> wrote:
> The reason why I'm suggestin it is because PCAnywhere is perhaps
> trying to synchromize files between the client and host (including
> your .mdb) which is maybe still and remains in use by the Sync Process
> when the VPN times out or disconnects.
Yeah, I don't think that's it. I tried connecting to the VPN without doing
anything else, and the results were the same. Something in SQL Server itself
is looking at that other server for some reason. Maybe because they both
have same-named databases. I don't know.
Thanks,
Neil
|||Not really, but you may try adding an entry to your host file pointing to
your local box and using the loopback IP. My vague guess is that possibly
you're getting into a situation where you get an IP through VPN and it
doesn't resolve the new IP when you get disconnected. Mind you, that's just
a guess, but it's all I've got right now.
Anyway, try the host file thing and see if that does anything for you.
"Neil" wrote:

> I work on a local copy of a database (Access 2000 MDB with ODBC linked
> tables to a SQL 7 database). The SQL Server db I'm working with is on my C
> drive (MSDE). Occasionally I'll connect to a VPN to do something on a remote
> computer, using PC Anywhere to perform the task. Doesn't involve my front or
> back end at all, except that the computer I'm VPNing to has a SQL database
> running.
> OK, so I'm using my db; I connect to the VPN, and do my thing. Everything's
> fine. However, if I then disconnect from the VPN (or if the VPN connection
> times out and disconnects itself), I then can no longer access my local SQL
> Server database. My Access application still works fine, as long as it
> doesn't have to look at any data. When it does have to look at data, I get
> ODBC call failed. I have to close and reopen my Access database, and then
> everything is fine.
> So, it seems that, for some reason, when I connect to the VPN, my local SQL
> Server or the ODBC driver or something in the mix is looking at that remote
> database as part of what I'm using. Then, when the VPN connection is closed,
> it won't access my local database for some reason.
> Oh, and my local database and the remote database both have the same name.
> So that may be part of the problem.
> Any ideas as to what's going on?
> Thanks!
> Neil
>
>

Local DB Affected By VPN

I work on a local copy of a database (Access 2000 MDB with ODBC linked
tables to a SQL 7 database). The SQL Server db I'm working with is on my C
drive (MSDE). Occasionally I'll connect to a VPN to do something on a remote
computer, using PC Anywhere to perform the task. Doesn't involve my front or
back end at all, except that the computer I'm VPNing to has a SQL database
running.

OK, so I'm using my db; I connect to the VPN, and do my thing. Everything's
fine. However, if I then disconnect from the VPN (or if the VPN connection
times out and disconnects itself), I then can no longer access my local SQL
Server database. My Access application still works fine, as long as it
doesn't have to look at any data. When it does have to look at data, I get
ODBC call failed. I have to close and reopen my Access database, and then
everything is fine.

So, it seems that, for some reason, when I connect to the VPN, my local SQL
Server or the ODBC driver or something in the mix is looking at that remote
database as part of what I'm using. Then, when the VPN connection is closed,
it won't access my local database for some reason.

Oh, and my local database and the remote database both have the same name.
So that may be part of the problem.

Any ideas as to what's going on?

Thanks!

NeilOn 26 Nov, 10:15, "Neil" <nos...@.nospam.netwrote:

Quote:

Originally Posted by

I work on a local copy of a database (Access 2000 MDB with ODBC linked
tables to a SQL 7 database). The SQL Server db I'm working with is on my C
drive (MSDE). Occasionally I'll connect to a VPN to do something on a remote
computer, using PC Anywhere to perform the task. Doesn't involve my front or
back end at all, except that the computer I'm VPNing to has a SQL database
running.
>
OK, so I'm using my db; I connect to the VPN, and do my thing. Everything's
fine. However, if I then disconnect from the VPN (or if the VPN connection
times out and disconnects itself), I then can no longer access my local SQL
Server database. My Access application still works fine, as long as it
doesn't have to look at any data. When it does have to look at data, I get
ODBC call failed. I have to close and reopen my Access database, and then
everything is fine.
>
So, it seems that, for some reason, when I connect to the VPN, my local SQL
Server or the ODBC driver or something in the mix is looking at that remote
database as part of what I'm using. Then, when the VPN connection is closed,
it won't access my local database for some reason.
>
Oh, and my local database and the remote database both have the same name.
So that may be part of the problem.
>
Any ideas as to what's going on?
>
Thanks!
>
Neil


It's only a guess but have you got the means of using Remote Desktop
Terminal Services Client or MSN Messenger Remote Assistance (As a
test) instead of PCAnywhere? I worked on the Laplink support line many
years ago and can imagine that this might be the issue and rings some
bells but things have changed since.

All the best,

Martin|||On 27 Nov, 13:46, theintrepidfox <theintrepid...@.hotmail.comwrote:

Quote:

Originally Posted by

On 26 Nov, 10:15, "Neil" <nos...@.nospam.netwrote:
>
>
>
>
>

Quote:

Originally Posted by

I work on a local copy of a database (Access 2000 MDB with ODBC linked
tables to a SQL 7 database). The SQL Server db I'm working with is on my C
drive (MSDE). Occasionally I'll connect to a VPN to do something on a remote
computer, using PC Anywhere to perform the task. Doesn't involve my front or
back end at all, except that the computer I'm VPNing to has a SQL database
running.


>

Quote:

Originally Posted by

OK, so I'm using my db; I connect to the VPN, and do my thing. Everything's
fine. However, if I then disconnect from the VPN (or if the VPN connection
times out and disconnects itself), I then can no longer access my local SQL
Server database. My Access application still works fine, as long as it
doesn't have to look at any data. When it does have to look at data, I get
ODBC call failed. I have to close and reopen my Access database, and then
everything is fine.


>

Quote:

Originally Posted by

So, it seems that, for some reason, when I connect to the VPN, my local SQL
Server or the ODBC driver or something in the mix is looking at that remote
database as part of what I'm using. Then, when the VPN connection is closed,
it won't access my local database for some reason.


>

Quote:

Originally Posted by

Oh, and my local database and the remote database both have the same name.
So that may be part of the problem.


>

Quote:

Originally Posted by

Any ideas as to what's going on?


>

Quote:

Originally Posted by

Thanks!


>

Quote:

Originally Posted by

Neil


>
It's only a guess but have you got the means of using Remote Desktop
Terminal Services Client or MSN Messenger Remote Assistance (As a
test) instead of PCAnywhere? I worked on the Laplink support line many
years ago and can imagine that this might be the issue and rings some
bells but things have changed since.
>
All the best,
>
Martin- Hide quoted text -
>
- Show quoted text -


The reason why I'm suggestin it is because PCAnywhere is perhaps
trying to synchromize files between the client and host (including
your .mdb) which is maybe still and remains in use by the Sync Process
when the VPN times out or disconnects.|||Actually, it usually happens after PCAnywhere has been closed. While
PCAnywhere is open, the VPN connection stays active. After I close
PCAnywhere, if I don't disconnect from the VPN, then eventually the VPN
connection times out.

So, a typical scenario is: open Access app connected to local SQL Server;
later, connect to VPN and do stuff via PCAnywhere; close PCAnywhere; later,
VPN connection disconnects, and then connection to local SQL Server fails.
Have to close and reopen MDB for it to work.

Strange...

"theintrepidfox" <theintrepidfox@.hotmail.comwrote in message
news:3e278590-302d-4549-82d4-2e12c0b51b1a@.i29g2000prf.googlegroups.com...

Quote:

Originally Posted by

On 26 Nov, 10:15, "Neil" <nos...@.nospam.netwrote:

Quote:

Originally Posted by

>I work on a local copy of a database (Access 2000 MDB with ODBC linked
>tables to a SQL 7 database). The SQL Server db I'm working with is on my
>C
>drive (MSDE). Occasionally I'll connect to a VPN to do something on a
>remote
>computer, using PC Anywhere to perform the task. Doesn't involve my front
>or
>back end at all, except that the computer I'm VPNing to has a SQL
>database
>running.
>>
>OK, so I'm using my db; I connect to the VPN, and do my thing.
>Everything's
>fine. However, if I then disconnect from the VPN (or if the VPN
>connection
>times out and disconnects itself), I then can no longer access my local
>SQL
>Server database. My Access application still works fine, as long as it
>doesn't have to look at any data. When it does have to look at data, I
>get
>ODBC call failed. I have to close and reopen my Access database, and then
>everything is fine.
>>
>So, it seems that, for some reason, when I connect to the VPN, my local
>SQL
>Server or the ODBC driver or something in the mix is looking at that
>remote
>database as part of what I'm using. Then, when the VPN connection is
>closed,
>it won't access my local database for some reason.
>>
>Oh, and my local database and the remote database both have the same
>name.
>So that may be part of the problem.
>>
>Any ideas as to what's going on?
>>
>Thanks!
>>
>Neil


>
It's only a guess but have you got the means of using Remote Desktop
Terminal Services Client or MSN Messenger Remote Assistance (As a
test) instead of PCAnywhere? I worked on the Laplink support line many
years ago and can imagine that this might be the issue and rings some
bells but things have changed since.
>
All the best,
>
Martin

|||"theintrepidfox" <theintrepidfox@.hotmail.comwrote in message
news:9cb60b5b-5160-4afe-8555-8ed2bed12b09@.s36g2000prg.googlegroups.com...

Quote:

Originally Posted by

On 27 Nov, 13:46, theintrepidfox <theintrepid...@.hotmail.comwrote:

Quote:

Originally Posted by

>On 26 Nov, 10:15, "Neil" <nos...@.nospam.netwrote:
>>
>>
>>
>>
>>

Quote:

Originally Posted by

I work on a local copy of a database (Access 2000 MDB with ODBC linked
tables to a SQL 7 database). The SQL Server db I'm working with is on
my C
drive (MSDE). Occasionally I'll connect to a VPN to do something on a
remote
computer, using PC Anywhere to perform the task. Doesn't involve my
front or
back end at all, except that the computer I'm VPNing to has a SQL
database
running.


>>

Quote:

Originally Posted by

OK, so I'm using my db; I connect to the VPN, and do my thing.
Everything's
fine. However, if I then disconnect from the VPN (or if the VPN
connection
times out and disconnects itself), I then can no longer access my local
SQL
Server database. My Access application still works fine, as long as it
doesn't have to look at any data. When it does have to look at data, I
get
ODBC call failed. I have to close and reopen my Access database, and
then
everything is fine.


>>

Quote:

Originally Posted by

So, it seems that, for some reason, when I connect to the VPN, my local
SQL
Server or the ODBC driver or something in the mix is looking at that
remote
database as part of what I'm using. Then, when the VPN connection is
closed,
it won't access my local database for some reason.


>>

Quote:

Originally Posted by

Oh, and my local database and the remote database both have the same
name.
So that may be part of the problem.


>>

Quote:

Originally Posted by

Any ideas as to what's going on?


>>

Quote:

Originally Posted by

Thanks!


>>

Quote:

Originally Posted by

Neil


>>
>It's only a guess but have you got the means of using Remote Desktop
>Terminal Services Client or MSN Messenger Remote Assistance (As a
>test) instead of PCAnywhere? I worked on the Laplink support line many
>years ago and can imagine that this might be the issue and rings some
>bells but things have changed since.
>>
>All the best,
>>
>Martin- Hide quoted text -
>>
>- Show quoted text -


>
The reason why I'm suggestin it is because PCAnywhere is perhaps
trying to synchromize files between the client and host (including
your .mdb) which is maybe still and remains in use by the Sync Process
when the VPN times out or disconnects.


Yeah, I don't think that's it. I tried connecting to the VPN without doing
anything else, and the results were the same. Something in SQL Server itself
is looking at that other server for some reason. Maybe because they both
have same-named databases. I don't know.

Thanks,

Neil

Local DB Affected By VPN

I work on a local copy of a database (Access 2000 MDB with ODBC linked
tables to a SQL 7 database). The SQL Server db I'm working with is on my C
drive (MSDE). Occasionally I'll connect to a VPN to do something on a remote
computer, using PC Anywhere to perform the task. Doesn't involve my front or
back end at all, except that the computer I'm VPNing to has a SQL database
running.
OK, so I'm using my db; I connect to the VPN, and do my thing. Everything's
fine. However, if I then disconnect from the VPN (or if the VPN connection
times out and disconnects itself), I then can no longer access my local SQL
Server database. My Access application still works fine, as long as it
doesn't have to look at any data. When it does have to look at data, I get
ODBC call failed. I have to close and reopen my Access database, and then
everything is fine.
So, it seems that, for some reason, when I connect to the VPN, my local SQL
Server or the ODBC driver or something in the mix is looking at that remote
database as part of what I'm using. Then, when the VPN connection is closed,
it won't access my local database for some reason.
Oh, and my local database and the remote database both have the same name.
So that may be part of the problem.
Any ideas as to what's going on?
Thanks!
NeilOn 26 Nov, 10:15, "Neil" <nos...@.nospam.net> wrote:
> I work on a local copy of a database (Access 2000 MDB with ODBC linked
> tables to a SQL 7 database). The SQL Server db I'm working with is on my C
> drive (MSDE). Occasionally I'll connect to a VPN to do something on a remo
te
> computer, using PC Anywhere to perform the task. Doesn't involve my front
or
> back end at all, except that the computer I'm VPNing to has a SQL database
> running.
> OK, so I'm using my db; I connect to the VPN, and do my thing. Everything'
s
> fine. However, if I then disconnect from the VPN (or if the VPN connection
> times out and disconnects itself), I then can no longer access my local SQ
L
> Server database. My Access application still works fine, as long as it
> doesn't have to look at any data. When it does have to look at data, I ge
t
> ODBC call failed. I have to close and reopen my Access database, and then
> everything is fine.
> So, it seems that, for some reason, when I connect to the VPN, my local SQ
L
> Server or the ODBC driver or something in the mix is looking at that remot
e
> database as part of what I'm using. Then, when the VPN connection is close
d,
> it won't access my local database for some reason.
> Oh, and my local database and the remote database both have the same name.
> So that may be part of the problem.
> Any ideas as to what's going on?
> Thanks!
> Neil
It's only a guess but have you got the means of using Remote Desktop
Terminal Services Client or MSN Messenger Remote Assistance (As a
test) instead of PCAnywhere? I worked on the Laplink support line many
years ago and can imagine that this might be the issue and rings some
bells but things have changed since.
All the best,
Martin|||On 27 Nov, 13:46, theintrepidfox <theintrepid...@.hotmail.com> wrote:
> On 26 Nov, 10:15, "Neil" <nos...@.nospam.net> wrote:
>
>
>
>
>
>
>
>
>
> It's only a guess but have you got the means of using Remote Desktop
> Terminal Services Client or MSN Messenger Remote Assistance (As a
> test) instead of PCAnywhere? I worked on the Laplink support line many
> years ago and can imagine that this might be the issue and rings some
> bells but things have changed since.
> All the best,
> Martin- Hide quoted text -
> - Show quoted text -
The reason why I'm suggestin it is because PCAnywhere is perhaps
trying to synchromize files between the client and host (including
your .mdb) which is maybe still and remains in use by the Sync Process
when the VPN times out or disconnects.|||Actually, it usually happens after PCAnywhere has been closed. While
PCAnywhere is open, the VPN connection stays active. After I close
PCAnywhere, if I don't disconnect from the VPN, then eventually the VPN
connection times out.
So, a typical scenario is: open Access app connected to local SQL Server;
later, connect to VPN and do stuff via PCAnywhere; close PCAnywhere; later,
VPN connection disconnects, and then connection to local SQL Server fails.
Have to close and reopen MDB for it to work.
Strange...
"theintrepidfox" <theintrepidfox@.hotmail.com> wrote in message
news:3e278590-302d-4549-82d4-2e12c0b51b1a@.i29g2000prf.googlegroups.com...
> On 26 Nov, 10:15, "Neil" <nos...@.nospam.net> wrote:
> It's only a guess but have you got the means of using Remote Desktop
> Terminal Services Client or MSN Messenger Remote Assistance (As a
> test) instead of PCAnywhere? I worked on the Laplink support line many
> years ago and can imagine that this might be the issue and rings some
> bells but things have changed since.
> All the best,
> Martin|||"theintrepidfox" <theintrepidfox@.hotmail.com> wrote in message
news:9cb60b5b-5160-4afe-8555-8ed2bed12b09@.s36g2000prg.googlegroups.com...
> On 27 Nov, 13:46, theintrepidfox <theintrepid...@.hotmail.com> wrote:
> The reason why I'm suggestin it is because PCAnywhere is perhaps
> trying to synchromize files between the client and host (including
> your .mdb) which is maybe still and remains in use by the Sync Process
> when the VPN times out or disconnects.
Yeah, I don't think that's it. I tried connecting to the VPN without doing
anything else, and the results were the same. Something in SQL Server itself
is looking at that other server for some reason. Maybe because they both
have same-named databases. I don't know.
Thanks,
Neil|||Not really, but you may try adding an entry to your host file pointing to
your local box and using the loopback IP. My vague guess is that possibly
you're getting into a situation where you get an IP through VPN and it
doesn't resolve the new IP when you get disconnected. Mind you, that's just
a guess, but it's all I've got right now.
Anyway, try the host file thing and see if that does anything for you.
"Neil" wrote:

> I work on a local copy of a database (Access 2000 MDB with ODBC linked
> tables to a SQL 7 database). The SQL Server db I'm working with is on my C
> drive (MSDE). Occasionally I'll connect to a VPN to do something on a remo
te
> computer, using PC Anywhere to perform the task. Doesn't involve my front
or
> back end at all, except that the computer I'm VPNing to has a SQL database
> running.
> OK, so I'm using my db; I connect to the VPN, and do my thing. Everything'
s
> fine. However, if I then disconnect from the VPN (or if the VPN connection
> times out and disconnects itself), I then can no longer access my local SQ
L
> Server database. My Access application still works fine, as long as it
> doesn't have to look at any data. When it does have to look at data, I ge
t
> ODBC call failed. I have to close and reopen my Access database, and then
> everything is fine.
> So, it seems that, for some reason, when I connect to the VPN, my local SQ
L
> Server or the ODBC driver or something in the mix is looking at that remot
e
> database as part of what I'm using. Then, when the VPN connection is close
d,
> it won't access my local database for some reason.
> Oh, and my local database and the remote database both have the same name.
> So that may be part of the problem.
> Any ideas as to what's going on?
> Thanks!
> Neil
>
>

Local Database Issue with SQL 2000 Install

I've got a user with a new HP desktop requesting SQL 2000 Developer Server
and Client Tools to be installed. When I install the software along with SQL
SP4, the local database shows up in Enterprise Manager. When the user logs
on to the same machine, the local database is missing in Enterprise Manager.
I had another user with the same type of permissions log on to the machine
and they get the local database to show up as well.
Why can't this particular person get the local database to show up in
Enterprise Manger when they log on? Is there a registry edit that's needed?
Any help is greatly appreciated.
Colette
Hi Colette,
Perhaps it's been removed. Have they tried just registering the server in
Enterprise Manager? (ie: right-click the SQL Servers group in the main tree
and choose the option to register a server)
HTH,
Greg
"Colette" <Colette@.discussions.microsoft.com> wrote in message
news:084583C7-EA4C-4BC5-8EA1-1D0F448FDA32@.microsoft.com...
> I've got a user with a new HP desktop requesting SQL 2000 Developer Server
> and Client Tools to be installed. When I install the software along with
> SQL
> SP4, the local database shows up in Enterprise Manager. When the user
> logs
> on to the same machine, the local database is missing in Enterprise
> Manager.
> I had another user with the same type of permissions log on to the machine
> and they get the local database to show up as well.
> Why can't this particular person get the local database to show up in
> Enterprise Manger when they log on? Is there a registry edit that's
> needed?
> Any help is greatly appreciated.
> Colette

Local Database Issue with SQL 2000 Install

I've got a user with a new HP desktop requesting SQL 2000 Developer Server
and Client Tools to be installed. When I install the software along with SQL
SP4, the local database shows up in Enterprise Manager. When the user logs
on to the same machine, the local database is missing in Enterprise Manager.
I had another user with the same type of permissions log on to the machine
and they get the local database to show up as well.
Why can't this particular person get the local database to show up in
Enterprise Manger when they log on? Is there a registry edit that's needed?
Any help is greatly appreciated.
ColetteHi Colette,
Perhaps it's been removed. Have they tried just registering the server in
Enterprise Manager? (ie: right-click the SQL Servers group in the main tree
and choose the option to register a server)
HTH,
Greg
"Colette" <Colette@.discussions.microsoft.com> wrote in message
news:084583C7-EA4C-4BC5-8EA1-1D0F448FDA32@.microsoft.com...
> I've got a user with a new HP desktop requesting SQL 2000 Developer Server
> and Client Tools to be installed. When I install the software along with
> SQL
> SP4, the local database shows up in Enterprise Manager. When the user
> logs
> on to the same machine, the local database is missing in Enterprise
> Manager.
> I had another user with the same type of permissions log on to the machine
> and they get the local database to show up as well.
> Why can't this particular person get the local database to show up in
> Enterprise Manger when they log on? Is there a registry edit that's
> needed?
> Any help is greatly appreciated.
> Colette

Local Database Issue with SQL 2000 Install

I've got a user with a new HP desktop requesting SQL 2000 Developer Server
and Client Tools to be installed. When I install the software along with SQ
L
SP4, the local database shows up in Enterprise Manager. When the user logs
on to the same machine, the local database is missing in Enterprise Manager.
I had another user with the same type of permissions log on to the machine
and they get the local database to show up as well.
Why can't this particular person get the local database to show up in
Enterprise Manger when they log on? Is there a registry edit that's needed?
Any help is greatly appreciated.
ColetteHi Colette,
Perhaps it's been removed. Have they tried just registering the server in
Enterprise Manager? (ie: right-click the SQL Servers group in the main tree
and choose the option to register a server)
HTH,
Greg
"Colette" <Colette@.discussions.microsoft.com> wrote in message
news:084583C7-EA4C-4BC5-8EA1-1D0F448FDA32@.microsoft.com...
> I've got a user with a new HP desktop requesting SQL 2000 Developer Server
> and Client Tools to be installed. When I install the software along with
> SQL
> SP4, the local database shows up in Enterprise Manager. When the user
> logs
> on to the same machine, the local database is missing in Enterprise
> Manager.
> I had another user with the same type of permissions log on to the machine
> and they get the local database to show up as well.
> Why can't this particular person get the local database to show up in
> Enterprise Manger when they log on? Is there a registry edit that's
> needed?
> Any help is greatly appreciated.
> Colette

local database in c#

Hi,

I want to create a database in a path specified by the user at runtime when he selects a menu item like File/New. My preference is to not require the user to run an sql server on his machine to run my application. All my searches on the web for this keep directing me to the code that creates a database on an sql server but I don't want that. I want the application to create the database at runtime at a place where the user chooses. I would appreciate either a snippet of code or a link to somewhere helpful please.

Hi,

MS Access is the solution for u. It does not require any extra files to work. It just need MDAC to be installed and it's shipped with Windows.

All u have to do is to create ure database with all tables, views,... with no data. Ship the empty database with ure application and when the user wants to create a new database u just copy the empty database to the user location.

HTH.

Hayder Marzouk

|||Thanks Hayder.

If there is a way to do this with a local sql database, I would appreciate some sample code to see how to do it.
|||

Hi,

You may create a T-SQL script and then run the script to create a database.

Move from C# express forum to Sql server forum.

Thanks

|||

Not within your specified 'requirements'

My preference is to not require the user to run an sql server on his machine to run my application.

A 'Local' sql database will require that the user run or have access to a SQL Server.

As Hayder mentioned, an Access database is an excellent option and does not require that the user have access to, or install a SQL Server.