Accessing data in a different database?

Hi,
I'm using SQL Server 2000 and I would like to make a view in one database
that returns data from a second database on the same server/instance of SQL
Server. Is this possible? If so, how?
Thanks in advance,
LinnCREATE VIEW dbo.MyView
AS
SELECT <columns>
FROM DatabaseName.dbo.TableName;
GO
"Linn Kubler" <lkubler@.chartwellwisc2.com> wrote in message
news:OcjY0nvbGHA.4900@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I'm using SQL Server 2000 and I would like to make a view in one database
> that returns data from a second database on the same server/instance of
> SQL Server. Is this possible? If so, how?
> Thanks in advance,
> Linn
>|||Assuming that you have appropriate permissions set up, simply use
three-part naming:
SELECT columnList
FROM OtherDatabase.DatabaseOwner.TableName
HTH,
Stu|||Ah yes, that worked great. Thanks Stu and Aaron for the help.
Linn
"Linn Kubler" <lkubler@.chartwellwisc2.com> wrote in message
news:OcjY0nvbGHA.4900@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I'm using SQL Server 2000 and I would like to make a view in one database
> that returns data from a second database on the same server/instance of
> SQL Server. Is this possible? If so, how?
> Thanks in advance,
> Linn
>

Accessing a remote SQL instance

Post moderated by XIII, please leave out the "irrrggent" in the subject line:

i'm using a SQL Server 2000.
now want i want is to make one of the machine on my local network
Machine one: i've installed the SQL Server 2000 with these settings
1) Use Local System
2) MixMode (Use Windows Authentication and SQL Server Authentication)
USER ID = sa
Password = sa
FromMachine tow which has the program: the connection string is:

<<< Me.SQLConnection_Search.ConnectionString = "packet size=4096;integrated security=SSPI; Persist Security Info=true; data source= "the name of the instance on Machine ONE"; user id=sa; password=sa; initial catalog=DBNEW; Server="Machine One Name">>>>>>>

when i connect --> "connect faild to MachineOne\Guest"

when i changed the SERVER to SERVER = "Machine One Name\User Account of the windows"
this message appear : "SQL Server does not exist or access is denied"

So what can i do.??

I'm not sure what your doing but the way I connect to local database is:
Dim cn As SqlConnection = New SqlConnection("workstation id=yourcomputername;packet size=4096;integrated security=SSPI;data source=yourcomputername;persist security info=False;initial catalog=yourdatabasename")

Access2000 Database(table) replicated to SQL 2000/2003 server

I'm trying to replicate a table(s) in access 2000 to MS SQL server 2000/2005 programatically on a timed instance and then have these tables merged in SQL to create one table.

Any guidance appreciated.

Thank you,

This isn't possible to do from MS SQL Server side using built-in Replication, Oracle is the only non-SQL Server database that can be published (in SQL Server 2005), you may want to post your question in an Access forum.

Access2000 Database(table) replicated to SQL 2000/2003 server

I'm trying to replicate a table(s) in access 2000 to MS SQL server 2000/2005 programatically on a timed instance and then have these tables merged in SQL to create one table.

Any guidance appreciated.

Thank you,

This isn't possible to do from MS SQL Server side using built-in Replication, Oracle is the only non-SQL Server database that can be published (in SQL Server 2005), you may want to post your question in an Access forum.

Access to SQL Express connection string

I need to hardcode my TCP port to a SQL Server Express named instance. You guys have any examples I could see. I keep getting an error when I try to connect:

Run-time error 2147467259 BBNETLIB connection open parse connection paramaters, invalid connection. I'm trying to connect to a local instance on a Windows 2003 server.

Please post your connection string.|||

CONNECTION=Provider=SQLOLEDB;Data Source=SQCTLxp1\C1SQLEXPRESS;User ID=sa;Password=!!Gulpp1!!;Initial Catalog=@.DBNAME;

I removed the semicolon at the end of the connection string and it worked. Thank You.

Access to SQL Express connection string

I need to hardcode my TCP port to a SQL Server Express named instance. You guys have any examples I could see. I keep getting an error when I try to connect:

Run-time error 2147467259 BBNETLIB connection open parse connection paramaters, invalid connection. I'm trying to connect to a local instance on a Windows 2003 server.

Please post your connection string.|||

CONNECTION=Provider=SQLOLEDB;Data Source=SQCTLxp1\C1SQLEXPRESS;User ID=sa;Password=!!Gulpp1!!;Initial Catalog=@.DBNAME;

I removed the semicolon at the end of the connection string and it worked. Thank You.

access SQL instance issue

I have a MSDE instance running on a server. I am able to start the services
for the
engine. But when I try to access the instance through "SQL Enterprise
Manager" I
get an error message.
"[server name] - SQL Server does not exist or access is denied."
I tried to access the instance through "Windows Authentication" and "SQL
Server Login" and I get the same error message.
I tried reinstalling "MSDE 2000A Desktop Engine" and SP4. I am able to start
the SQL services and I can restore a few databases from backup to the
instance.
Also during reinstallation of "MSDE 2000A Desktop Engine" I set the sa
password
using the SAPWD switch.
Questions:
Is there somthing that I am forgetting to do?
How can I access the instance through SQL Enterprise Manager?
Thanks in advanceGreg,
Instance? Have you tried servername\instancename?
HTH
Jerry
"Greg" <gregkh@.hotmail.com> wrote in message
news:40B1ACCA-63E6-4F99-9B0F-6FC8CBE54598@.microsoft.com...
>I have a MSDE instance running on a server. I am able to start the services
> for the
> engine. But when I try to access the instance through "SQL Enterprise
> Manager" I
> get an error message.
> "[server name] - SQL Server does not exist or access is denied."
> I tried to access the instance through "Windows Authentication" and "SQL
> Server Login" and I get the same error message.
> I tried reinstalling "MSDE 2000A Desktop Engine" and SP4. I am able to
> start
> the SQL services and I can restore a few databases from backup to the
> instance.
> Also during reinstallation of "MSDE 2000A Desktop Engine" I set the sa
> password
> using the SAPWD switch.
>
> Questions:
> Is there somthing that I am forgetting to do?
> How can I access the instance through SQL Enterprise Manager?
> Thanks in advance|||What do you mean servername\instancename?
There is no place to enter that info in SQL Enterprise Manager.
Is there anywhere else I can enter that info?
"Jerry Spivey" wrote:

> Greg,
> Instance? Have you tried servername\instancename?
> HTH
> Jerry
> "Greg" <gregkh@.hotmail.com> wrote in message
> news:40B1ACCA-63E6-4F99-9B0F-6FC8CBE54598@.microsoft.com...
>
>|||Greg,
I don't use MSDE but if EM sees it as another SQL Server and not the default
install then it probably sees it as a named instance. When you're
registering MSDE. For more information on named instances see:
http://msdn.microsoft.com/library/d.../>
up_2xmb.asp
HTH
Jerry
"Greg" <gregkh@.hotmail.com> wrote in message
news:CC7BA23C-241A-46A8-94E5-BA01B2D02722@.microsoft.com...[vbcol=seagreen]
> What do you mean servername\instancename?
> There is no place to enter that info in SQL Enterprise Manager.
> Is there anywhere else I can enter that info?
> "Jerry Spivey" wrote:
>|||Unfortunatly that did not help. I do not have SQL Server installed. Just an
MSDE instance. I need to access thaat instance from SQL Enterprise Manager.
I
only installed EM from the SQL 2000 CD so that I can access the MSDE instanc
e.
How about this, How do I put the MSDE instance in single-user mode?
"Jerry Spivey" wrote:

> Greg,
> I don't use MSDE but if EM sees it as another SQL Server and not the defau
lt
> install then it probably sees it as a named instance. When you're
> registering MSDE. For more information on named instances see:
> http://msdn.microsoft.com/library/d...
etup_2xmb.asp
> HTH
> Jerry
> "Greg" <gregkh@.hotmail.com> wrote in message
> news:CC7BA23C-241A-46A8-94E5-BA01B2D02722@.microsoft.com...
>
>|||Greg,
So MSDE is the only SQL Server installed? Try registering with the machine
IP address. Or if that doesn't work try:
(local)
HTH
Jerry
"Greg" <gregkh@.hotmail.com> wrote in message
news:A8E51772-6107-439F-A415-BB13EA4B1B31@.microsoft.com...[vbcol=seagreen]
> Unfortunatly that did not help. I do not have SQL Server installed. Just
> an
> MSDE instance. I need to access thaat instance from SQL Enterprise
> Manager. I
> only installed EM from the SQL 2000 CD so that I can access the MSDE
> instance.
> How about this, How do I put the MSDE instance in single-user mode?
>
> "Jerry Spivey" wrote:
>|||EM and the MSDE instance are on the same machine. I tried local and IP
address and I still get the same error. Is there anything that I am
forgetting to do?
"Jerry Spivey" wrote:

> Greg,
> So MSDE is the only SQL Server installed? Try registering with the machin
e
> IP address. Or if that doesn't work try:
> (local)
> HTH
> Jerry
>
> "Greg" <gregkh@.hotmail.com> wrote in message
> news:A8E51772-6107-439F-A415-BB13EA4B1B31@.microsoft.com...
>
>|||Oh and yes MSDE is the only SQL Server that is installed.
"Greg" wrote:
[vbcol=seagreen]
> EM and the MSDE instance are on the same machine. I tried local and IP
> address and I still get the same error. Is there anything that I am
> forgetting to do?
> "Jerry Spivey" wrote:
>

access SQL instance issue

I have a MSDE instance running on a server. I am able to start the services
for the
engine. But when I try to access the instance through "SQL Enterprise
Manager" I
get an error message.
"[server name] - SQL Server does not exist or access is denied."
I tried to access the instance through "Windows Authentication" and "SQL
Server Login" and I get the same error message.
I tried reinstalling "MSDE 2000A Desktop Engine" and SP4. I am able to start
the SQL services and I can restore a few databases from backup to the
instance.
Also during reinstallation of "MSDE 2000A Desktop Engine" I set the sa
password
using the SAPWD switch.
Questions:
Is there somthing that I am forgetting to do?
How can I access the instance through SQL Enterprise Manager?
Thanks in advance
Greg,
Instance? Have you tried servername\instancename?
HTH
Jerry
"Greg" <gregkh@.hotmail.com> wrote in message
news:40B1ACCA-63E6-4F99-9B0F-6FC8CBE54598@.microsoft.com...
>I have a MSDE instance running on a server. I am able to start the services
> for the
> engine. But when I try to access the instance through "SQL Enterprise
> Manager" I
> get an error message.
> "[server name] - SQL Server does not exist or access is denied."
> I tried to access the instance through "Windows Authentication" and "SQL
> Server Login" and I get the same error message.
> I tried reinstalling "MSDE 2000A Desktop Engine" and SP4. I am able to
> start
> the SQL services and I can restore a few databases from backup to the
> instance.
> Also during reinstallation of "MSDE 2000A Desktop Engine" I set the sa
> password
> using the SAPWD switch.
>
> Questions:
> Is there somthing that I am forgetting to do?
> How can I access the instance through SQL Enterprise Manager?
> Thanks in advance
|||What do you mean servername\instancename?
There is no place to enter that info in SQL Enterprise Manager.
Is there anywhere else I can enter that info?
"Jerry Spivey" wrote:

> Greg,
> Instance? Have you tried servername\instancename?
> HTH
> Jerry
> "Greg" <gregkh@.hotmail.com> wrote in message
> news:40B1ACCA-63E6-4F99-9B0F-6FC8CBE54598@.microsoft.com...
>
>
|||Greg,
I don't use MSDE but if EM sees it as another SQL Server and not the default
install then it probably sees it as a named instance. When you're
registering MSDE. For more information on named instances see:
http://msdn.microsoft.com/library/de...setup_2xmb.asp
HTH
Jerry
"Greg" <gregkh@.hotmail.com> wrote in message
news:CC7BA23C-241A-46A8-94E5-BA01B2D02722@.microsoft.com...[vbcol=seagreen]
> What do you mean servername\instancename?
> There is no place to enter that info in SQL Enterprise Manager.
> Is there anywhere else I can enter that info?
> "Jerry Spivey" wrote:
|||Unfortunatly that did not help. I do not have SQL Server installed. Just an
MSDE instance. I need to access thaat instance from SQL Enterprise Manager. I
only installed EM from the SQL 2000 CD so that I can access the MSDE instance.
How about this, How do I put the MSDE instance in single-user mode?
"Jerry Spivey" wrote:

> Greg,
> I don't use MSDE but if EM sees it as another SQL Server and not the default
> install then it probably sees it as a named instance. When you're
> registering MSDE. For more information on named instances see:
> http://msdn.microsoft.com/library/de...setup_2xmb.asp
> HTH
> Jerry
> "Greg" <gregkh@.hotmail.com> wrote in message
> news:CC7BA23C-241A-46A8-94E5-BA01B2D02722@.microsoft.com...
>
>
|||Greg,
So MSDE is the only SQL Server installed? Try registering with the machine
IP address. Or if that doesn't work try:
(local)
HTH
Jerry
"Greg" <gregkh@.hotmail.com> wrote in message
news:A8E51772-6107-439F-A415-BB13EA4B1B31@.microsoft.com...[vbcol=seagreen]
> Unfortunatly that did not help. I do not have SQL Server installed. Just
> an
> MSDE instance. I need to access thaat instance from SQL Enterprise
> Manager. I
> only installed EM from the SQL 2000 CD so that I can access the MSDE
> instance.
> How about this, How do I put the MSDE instance in single-user mode?
>
> "Jerry Spivey" wrote:
|||EM and the MSDE instance are on the same machine. I tried local and IP
address and I still get the same error. Is there anything that I am
forgetting to do?
"Jerry Spivey" wrote:

> Greg,
> So MSDE is the only SQL Server installed? Try registering with the machine
> IP address. Or if that doesn't work try:
> (local)
> HTH
> Jerry
>
> "Greg" <gregkh@.hotmail.com> wrote in message
> news:A8E51772-6107-439F-A415-BB13EA4B1B31@.microsoft.com...
>
>
|||Oh and yes MSDE is the only SQL Server that is installed.
"Greg" wrote:
[vbcol=seagreen]
> EM and the MSDE instance are on the same machine. I tried local and IP
> address and I still get the same error. Is there anything that I am
> forgetting to do?
> "Jerry Spivey" wrote:

access SQL instance issue

I have a MSDE instance running on a server. I am able to start the services
for the
engine. But when I try to access the instance through "SQL Enterprise
Manager" I
get an error message.
"[server name] - SQL Server does not exist or access is denied."
I tried to access the instance through "Windows Authentication" and "SQL
Server Login" and I get the same error message.
I tried reinstalling "MSDE 2000A Desktop Engine" and SP4. I am able to start
the SQL services and I can restore a few databases from backup to the
instance.
Also during reinstallation of "MSDE 2000A Desktop Engine" I set the sa
password
using the SAPWD switch.
Questions:
Is there somthing that I am forgetting to do?
How can I access the instance through SQL Enterprise Manager?
Thanks in advanceGreg,
Instance? Have you tried servername\instancename?
HTH
Jerry
"Greg" <gregkh@.hotmail.com> wrote in message
news:40B1ACCA-63E6-4F99-9B0F-6FC8CBE54598@.microsoft.com...
>I have a MSDE instance running on a server. I am able to start the services
> for the
> engine. But when I try to access the instance through "SQL Enterprise
> Manager" I
> get an error message.
> "[server name] - SQL Server does not exist or access is denied."
> I tried to access the instance through "Windows Authentication" and "SQL
> Server Login" and I get the same error message.
> I tried reinstalling "MSDE 2000A Desktop Engine" and SP4. I am able to
> start
> the SQL services and I can restore a few databases from backup to the
> instance.
> Also during reinstallation of "MSDE 2000A Desktop Engine" I set the sa
> password
> using the SAPWD switch.
>
> Questions:
> Is there somthing that I am forgetting to do?
> How can I access the instance through SQL Enterprise Manager?
> Thanks in advance|||What do you mean servername\instancename?
There is no place to enter that info in SQL Enterprise Manager.
Is there anywhere else I can enter that info?
"Jerry Spivey" wrote:
> Greg,
> Instance? Have you tried servername\instancename?
> HTH
> Jerry
> "Greg" <gregkh@.hotmail.com> wrote in message
> news:40B1ACCA-63E6-4F99-9B0F-6FC8CBE54598@.microsoft.com...
> >I have a MSDE instance running on a server. I am able to start the services
> > for the
> > engine. But when I try to access the instance through "SQL Enterprise
> > Manager" I
> > get an error message.
> >
> > "[server name] - SQL Server does not exist or access is denied."
> >
> > I tried to access the instance through "Windows Authentication" and "SQL
> > Server Login" and I get the same error message.
> >
> > I tried reinstalling "MSDE 2000A Desktop Engine" and SP4. I am able to
> > start
> > the SQL services and I can restore a few databases from backup to the
> > instance.
> > Also during reinstallation of "MSDE 2000A Desktop Engine" I set the sa
> > password
> > using the SAPWD switch.
> >
> >
> > Questions:
> > Is there somthing that I am forgetting to do?
> > How can I access the instance through SQL Enterprise Manager?
> >
> > Thanks in advance
>
>|||Greg,
I don't use MSDE but if EM sees it as another SQL Server and not the default
install then it probably sees it as a named instance. When you're
registering MSDE. For more information on named instances see:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_runsetup_2xmb.asp
HTH
Jerry
"Greg" <gregkh@.hotmail.com> wrote in message
news:CC7BA23C-241A-46A8-94E5-BA01B2D02722@.microsoft.com...
> What do you mean servername\instancename?
> There is no place to enter that info in SQL Enterprise Manager.
> Is there anywhere else I can enter that info?
> "Jerry Spivey" wrote:
>> Greg,
>> Instance? Have you tried servername\instancename?
>> HTH
>> Jerry
>> "Greg" <gregkh@.hotmail.com> wrote in message
>> news:40B1ACCA-63E6-4F99-9B0F-6FC8CBE54598@.microsoft.com...
>> >I have a MSDE instance running on a server. I am able to start the
>> >services
>> > for the
>> > engine. But when I try to access the instance through "SQL Enterprise
>> > Manager" I
>> > get an error message.
>> >
>> > "[server name] - SQL Server does not exist or access is denied."
>> >
>> > I tried to access the instance through "Windows Authentication" and
>> > "SQL
>> > Server Login" and I get the same error message.
>> >
>> > I tried reinstalling "MSDE 2000A Desktop Engine" and SP4. I am able to
>> > start
>> > the SQL services and I can restore a few databases from backup to the
>> > instance.
>> > Also during reinstallation of "MSDE 2000A Desktop Engine" I set the sa
>> > password
>> > using the SAPWD switch.
>> >
>> >
>> > Questions:
>> > Is there somthing that I am forgetting to do?
>> > How can I access the instance through SQL Enterprise Manager?
>> >
>> > Thanks in advance
>>|||Unfortunatly that did not help. I do not have SQL Server installed. Just an
MSDE instance. I need to access thaat instance from SQL Enterprise Manager. I
only installed EM from the SQL 2000 CD so that I can access the MSDE instance.
How about this, How do I put the MSDE instance in single-user mode?
"Jerry Spivey" wrote:
> Greg,
> I don't use MSDE but if EM sees it as another SQL Server and not the default
> install then it probably sees it as a named instance. When you're
> registering MSDE. For more information on named instances see:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_runsetup_2xmb.asp
> HTH
> Jerry
> "Greg" <gregkh@.hotmail.com> wrote in message
> news:CC7BA23C-241A-46A8-94E5-BA01B2D02722@.microsoft.com...
> > What do you mean servername\instancename?
> > There is no place to enter that info in SQL Enterprise Manager.
> >
> > Is there anywhere else I can enter that info?
> >
> > "Jerry Spivey" wrote:
> >
> >> Greg,
> >>
> >> Instance? Have you tried servername\instancename?
> >>
> >> HTH
> >>
> >> Jerry
> >> "Greg" <gregkh@.hotmail.com> wrote in message
> >> news:40B1ACCA-63E6-4F99-9B0F-6FC8CBE54598@.microsoft.com...
> >> >I have a MSDE instance running on a server. I am able to start the
> >> >services
> >> > for the
> >> > engine. But when I try to access the instance through "SQL Enterprise
> >> > Manager" I
> >> > get an error message.
> >> >
> >> > "[server name] - SQL Server does not exist or access is denied."
> >> >
> >> > I tried to access the instance through "Windows Authentication" and
> >> > "SQL
> >> > Server Login" and I get the same error message.
> >> >
> >> > I tried reinstalling "MSDE 2000A Desktop Engine" and SP4. I am able to
> >> > start
> >> > the SQL services and I can restore a few databases from backup to the
> >> > instance.
> >> > Also during reinstallation of "MSDE 2000A Desktop Engine" I set the sa
> >> > password
> >> > using the SAPWD switch.
> >> >
> >> >
> >> > Questions:
> >> > Is there somthing that I am forgetting to do?
> >> > How can I access the instance through SQL Enterprise Manager?
> >> >
> >> > Thanks in advance
> >>
> >>
> >>
>
>|||Greg,
So MSDE is the only SQL Server installed? Try registering with the machine
IP address. Or if that doesn't work try:
(local)
HTH
Jerry
"Greg" <gregkh@.hotmail.com> wrote in message
news:A8E51772-6107-439F-A415-BB13EA4B1B31@.microsoft.com...
> Unfortunatly that did not help. I do not have SQL Server installed. Just
> an
> MSDE instance. I need to access thaat instance from SQL Enterprise
> Manager. I
> only installed EM from the SQL 2000 CD so that I can access the MSDE
> instance.
> How about this, How do I put the MSDE instance in single-user mode?
>
> "Jerry Spivey" wrote:
>> Greg,
>> I don't use MSDE but if EM sees it as another SQL Server and not the
>> default
>> install then it probably sees it as a named instance. When you're
>> registering MSDE. For more information on named instances see:
>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_runsetup_2xmb.asp
>> HTH
>> Jerry
>> "Greg" <gregkh@.hotmail.com> wrote in message
>> news:CC7BA23C-241A-46A8-94E5-BA01B2D02722@.microsoft.com...
>> > What do you mean servername\instancename?
>> > There is no place to enter that info in SQL Enterprise Manager.
>> >
>> > Is there anywhere else I can enter that info?
>> >
>> > "Jerry Spivey" wrote:
>> >
>> >> Greg,
>> >>
>> >> Instance? Have you tried servername\instancename?
>> >>
>> >> HTH
>> >>
>> >> Jerry
>> >> "Greg" <gregkh@.hotmail.com> wrote in message
>> >> news:40B1ACCA-63E6-4F99-9B0F-6FC8CBE54598@.microsoft.com...
>> >> >I have a MSDE instance running on a server. I am able to start the
>> >> >services
>> >> > for the
>> >> > engine. But when I try to access the instance through "SQL
>> >> > Enterprise
>> >> > Manager" I
>> >> > get an error message.
>> >> >
>> >> > "[server name] - SQL Server does not exist or access is denied."
>> >> >
>> >> > I tried to access the instance through "Windows Authentication" and
>> >> > "SQL
>> >> > Server Login" and I get the same error message.
>> >> >
>> >> > I tried reinstalling "MSDE 2000A Desktop Engine" and SP4. I am able
>> >> > to
>> >> > start
>> >> > the SQL services and I can restore a few databases from backup to
>> >> > the
>> >> > instance.
>> >> > Also during reinstallation of "MSDE 2000A Desktop Engine" I set the
>> >> > sa
>> >> > password
>> >> > using the SAPWD switch.
>> >> >
>> >> >
>> >> > Questions:
>> >> > Is there somthing that I am forgetting to do?
>> >> > How can I access the instance through SQL Enterprise Manager?
>> >> >
>> >> > Thanks in advance
>> >>
>> >>
>> >>
>>|||EM and the MSDE instance are on the same machine. I tried local and IP
address and I still get the same error. Is there anything that I am
forgetting to do?
"Jerry Spivey" wrote:
> Greg,
> So MSDE is the only SQL Server installed? Try registering with the machine
> IP address. Or if that doesn't work try:
> (local)
> HTH
> Jerry
>
> "Greg" <gregkh@.hotmail.com> wrote in message
> news:A8E51772-6107-439F-A415-BB13EA4B1B31@.microsoft.com...
> > Unfortunatly that did not help. I do not have SQL Server installed. Just
> > an
> > MSDE instance. I need to access thaat instance from SQL Enterprise
> > Manager. I
> > only installed EM from the SQL 2000 CD so that I can access the MSDE
> > instance.
> >
> > How about this, How do I put the MSDE instance in single-user mode?
> >
> >
> > "Jerry Spivey" wrote:
> >
> >> Greg,
> >>
> >> I don't use MSDE but if EM sees it as another SQL Server and not the
> >> default
> >> install then it probably sees it as a named instance. When you're
> >> registering MSDE. For more information on named instances see:
> >>
> >> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_runsetup_2xmb.asp
> >>
> >> HTH
> >>
> >> Jerry
> >> "Greg" <gregkh@.hotmail.com> wrote in message
> >> news:CC7BA23C-241A-46A8-94E5-BA01B2D02722@.microsoft.com...
> >> > What do you mean servername\instancename?
> >> > There is no place to enter that info in SQL Enterprise Manager.
> >> >
> >> > Is there anywhere else I can enter that info?
> >> >
> >> > "Jerry Spivey" wrote:
> >> >
> >> >> Greg,
> >> >>
> >> >> Instance? Have you tried servername\instancename?
> >> >>
> >> >> HTH
> >> >>
> >> >> Jerry
> >> >> "Greg" <gregkh@.hotmail.com> wrote in message
> >> >> news:40B1ACCA-63E6-4F99-9B0F-6FC8CBE54598@.microsoft.com...
> >> >> >I have a MSDE instance running on a server. I am able to start the
> >> >> >services
> >> >> > for the
> >> >> > engine. But when I try to access the instance through "SQL
> >> >> > Enterprise
> >> >> > Manager" I
> >> >> > get an error message.
> >> >> >
> >> >> > "[server name] - SQL Server does not exist or access is denied."
> >> >> >
> >> >> > I tried to access the instance through "Windows Authentication" and
> >> >> > "SQL
> >> >> > Server Login" and I get the same error message.
> >> >> >
> >> >> > I tried reinstalling "MSDE 2000A Desktop Engine" and SP4. I am able
> >> >> > to
> >> >> > start
> >> >> > the SQL services and I can restore a few databases from backup to
> >> >> > the
> >> >> > instance.
> >> >> > Also during reinstallation of "MSDE 2000A Desktop Engine" I set the
> >> >> > sa
> >> >> > password
> >> >> > using the SAPWD switch.
> >> >> >
> >> >> >
> >> >> > Questions:
> >> >> > Is there somthing that I am forgetting to do?
> >> >> > How can I access the instance through SQL Enterprise Manager?
> >> >> >
> >> >> > Thanks in advance
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||Oh and yes MSDE is the only SQL Server that is installed.
"Greg" wrote:
> EM and the MSDE instance are on the same machine. I tried local and IP
> address and I still get the same error. Is there anything that I am
> forgetting to do?
> "Jerry Spivey" wrote:
> > Greg,
> >
> > So MSDE is the only SQL Server installed? Try registering with the machine
> > IP address. Or if that doesn't work try:
> >
> > (local)
> >
> > HTH
> >
> > Jerry
> >
> >
> > "Greg" <gregkh@.hotmail.com> wrote in message
> > news:A8E51772-6107-439F-A415-BB13EA4B1B31@.microsoft.com...
> > > Unfortunatly that did not help. I do not have SQL Server installed. Just
> > > an
> > > MSDE instance. I need to access thaat instance from SQL Enterprise
> > > Manager. I
> > > only installed EM from the SQL 2000 CD so that I can access the MSDE
> > > instance.
> > >
> > > How about this, How do I put the MSDE instance in single-user mode?
> > >
> > >
> > > "Jerry Spivey" wrote:
> > >
> > >> Greg,
> > >>
> > >> I don't use MSDE but if EM sees it as another SQL Server and not the
> > >> default
> > >> install then it probably sees it as a named instance. When you're
> > >> registering MSDE. For more information on named instances see:
> > >>
> > >> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_runsetup_2xmb.asp
> > >>
> > >> HTH
> > >>
> > >> Jerry
> > >> "Greg" <gregkh@.hotmail.com> wrote in message
> > >> news:CC7BA23C-241A-46A8-94E5-BA01B2D02722@.microsoft.com...
> > >> > What do you mean servername\instancename?
> > >> > There is no place to enter that info in SQL Enterprise Manager.
> > >> >
> > >> > Is there anywhere else I can enter that info?
> > >> >
> > >> > "Jerry Spivey" wrote:
> > >> >
> > >> >> Greg,
> > >> >>
> > >> >> Instance? Have you tried servername\instancename?
> > >> >>
> > >> >> HTH
> > >> >>
> > >> >> Jerry
> > >> >> "Greg" <gregkh@.hotmail.com> wrote in message
> > >> >> news:40B1ACCA-63E6-4F99-9B0F-6FC8CBE54598@.microsoft.com...
> > >> >> >I have a MSDE instance running on a server. I am able to start the
> > >> >> >services
> > >> >> > for the
> > >> >> > engine. But when I try to access the instance through "SQL
> > >> >> > Enterprise
> > >> >> > Manager" I
> > >> >> > get an error message.
> > >> >> >
> > >> >> > "[server name] - SQL Server does not exist or access is denied."
> > >> >> >
> > >> >> > I tried to access the instance through "Windows Authentication" and
> > >> >> > "SQL
> > >> >> > Server Login" and I get the same error message.
> > >> >> >
> > >> >> > I tried reinstalling "MSDE 2000A Desktop Engine" and SP4. I am able
> > >> >> > to
> > >> >> > start
> > >> >> > the SQL services and I can restore a few databases from backup to
> > >> >> > the
> > >> >> > instance.
> > >> >> > Also during reinstallation of "MSDE 2000A Desktop Engine" I set the
> > >> >> > sa
> > >> >> > password
> > >> >> > using the SAPWD switch.
> > >> >> >
> > >> >> >
> > >> >> > Questions:
> > >> >> > Is there somthing that I am forgetting to do?
> > >> >> > How can I access the instance through SQL Enterprise Manager?
> > >> >> >
> > >> >> > Thanks in advance
> > >> >>
> > >> >>
> > >> >>
> > >>
> > >>
> > >>
> >
> >
> >

Access MSSQL on diffrent port

Hi,
Im trying to access MSSQL 2000 instance on diffrent port using Query analyze
r
is this possible?
Marcin S.You can only connect through the port SQL Server is listening on...are you
wanting to change the port at the server level?
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
news:6FD75159-C14C-435C-880C-435CA35C2818@.microsoft.com...
> Hi,
> Im trying to access MSSQL 2000 instance on diffrent port using Query
> analyzer
> is this possible?
>
> --
> Marcin S.|||Hi,
I'm running two instances om the MSSQL server och they have differnt ports
1434 and 1435
I want to remotly to connect to 192.168.0.150:1434 and/or 192.168.0.150:1435
the both servers are on separeta DMZ and the SQL connection passing thru an
Firewall. I can telnet to this ports so the fire wall is working correct by
i
dont know how to specify a port in QA an in the connection string.
Marcin S.
"Kevin3NF" wrote:

> You can only connect through the port SQL Server is listening on...are you
> wanting to change the port at the server level?
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
> news:6FD75159-C14C-435C-880C-435CA35C2818@.microsoft.com...
>
>|||assuming you have a vpn connection established to get you on the local LAN:
tcp:192.168.0.150,1434
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
news:6914E943-4C67-43D9-A094-E4060570AFF4@.microsoft.com...[vbcol=seagreen]
> Hi,
> I'm running two instances om the MSSQL server och they have differnt ports
> 1434 and 1435
> I want to remotly to connect to 192.168.0.150:1434 and/or
> 192.168.0.150:1435
> the both servers are on separeta DMZ and the SQL connection passing thru
> an
> Firewall. I can telnet to this ports so the fire wall is working correct
> by i
> dont know how to specify a port in QA an in the connection string.
>
> --
> Marcin S.
>
> "Kevin3NF" wrote:
>|||No there is no VPN the SQL server is just separated from the webserver by a
firewall.
--
Marcin S.
"Kevin3NF" wrote:

> assuming you have a vpn connection established to get you on the local LAN
:
> tcp:192.168.0.150,1434
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
> news:6914E943-4C67-43D9-A094-E4060570AFF4@.microsoft.com...
>
>|||Hi,
this is almost working but i think i must specify the instance how to do tha
192.168.0.150\MSSQL2,1435 '
My instancename is MSSQL1 and MSSQL2
Marcin S.
"Kevin3NF" wrote:

> assuming you have a vpn connection established to get you on the local LAN
:
> tcp:192.168.0.150,1434
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
> news:6914E943-4C67-43D9-A094-E4060570AFF4@.microsoft.com...
>
>|||192.168.0.150\MSSQL2,1435 is correct.
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
news:4818A5FC-FE43-4C54-ABF9-25FA67B4C23D@.microsoft.com...[vbcol=seagreen]
> Hi,
> this is almost working but i think i must specify the instance how to do
> tha
> 192.168.0.150\MSSQL2,1435 '
> My instancename is MSSQL1 and MSSQL2
>
> --
> Marcin S.
>
> "Kevin3NF" wrote:
>

Access MSSQL on diffrent port

Hi,
Im trying to access MSSQL 2000 instance on diffrent port using Query analyzer
is this possible?
Marcin S.
You can only connect through the port SQL Server is listening on...are you
wanting to change the port at the server level?
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
news:6FD75159-C14C-435C-880C-435CA35C2818@.microsoft.com...
> Hi,
> Im trying to access MSSQL 2000 instance on diffrent port using Query
> analyzer
> is this possible?
>
> --
> Marcin S.
|||Hi,
I'm running two instances om the MSSQL server och they have differnt ports
1434 and 1435
I want to remotly to connect to 192.168.0.150:1434 and/or 192.168.0.150:1435
the both servers are on separeta DMZ and the SQL connection passing thru an
Firewall. I can telnet to this ports so the fire wall is working correct by i
dont know how to specify a port in QA an in the connection string.
Marcin S.
"Kevin3NF" wrote:

> You can only connect through the port SQL Server is listening on...are you
> wanting to change the port at the server level?
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
> news:6FD75159-C14C-435C-880C-435CA35C2818@.microsoft.com...
>
>
|||assuming you have a vpn connection established to get you on the local LAN:
tcp:192.168.0.150,1434
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
news:6914E943-4C67-43D9-A094-E4060570AFF4@.microsoft.com...[vbcol=seagreen]
> Hi,
> I'm running two instances om the MSSQL server och they have differnt ports
> 1434 and 1435
> I want to remotly to connect to 192.168.0.150:1434 and/or
> 192.168.0.150:1435
> the both servers are on separeta DMZ and the SQL connection passing thru
> an
> Firewall. I can telnet to this ports so the fire wall is working correct
> by i
> dont know how to specify a port in QA an in the connection string.
>
> --
> Marcin S.
>
> "Kevin3NF" wrote:
|||No there is no VPN the SQL server is just separated from the webserver by a
firewall.
--
Marcin S.
"Kevin3NF" wrote:

> assuming you have a vpn connection established to get you on the local LAN:
> tcp:192.168.0.150,1434
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
> news:6914E943-4C67-43D9-A094-E4060570AFF4@.microsoft.com...
>
>
|||Hi,
this is almost working but i think i must specify the instance how to do tha
192.168.0.150\MSSQL2,1435 ?
My instancename is MSSQL1 and MSSQL2
Marcin S.
"Kevin3NF" wrote:

> assuming you have a vpn connection established to get you on the local LAN:
> tcp:192.168.0.150,1434
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
> news:6914E943-4C67-43D9-A094-E4060570AFF4@.microsoft.com...
>
>
|||192.168.0.150\MSSQL2,1435 is correct.
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
news:4818A5FC-FE43-4C54-ABF9-25FA67B4C23D@.microsoft.com...[vbcol=seagreen]
> Hi,
> this is almost working but i think i must specify the instance how to do
> tha
> 192.168.0.150\MSSQL2,1435 ?
> My instancename is MSSQL1 and MSSQL2
>
> --
> Marcin S.
>
> "Kevin3NF" wrote:

Access MSSQL on diffrent port

Hi,
Im trying to access MSSQL 2000 instance on diffrent port using Query analyzer
is this possible?
--
Marcin S.You can only connect through the port SQL Server is listening on...are you
wanting to change the port at the server level?
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
news:6FD75159-C14C-435C-880C-435CA35C2818@.microsoft.com...
> Hi,
> Im trying to access MSSQL 2000 instance on diffrent port using Query
> analyzer
> is this possible?
>
> --
> Marcin S.|||Hi,
I'm running two instances om the MSSQL server och they have differnt ports
1434 and 1435
I want to remotly to connect to 192.168.0.150:1434 and/or 192.168.0.150:1435
the both servers are on separeta DMZ and the SQL connection passing thru an
Firewall. I can telnet to this ports so the fire wall is working correct by i
dont know how to specify a port in QA an in the connection string.
Marcin S.
"Kevin3NF" wrote:
> You can only connect through the port SQL Server is listening on...are you
> wanting to change the port at the server level?
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
> news:6FD75159-C14C-435C-880C-435CA35C2818@.microsoft.com...
> > Hi,
> >
> > Im trying to access MSSQL 2000 instance on diffrent port using Query
> > analyzer
> > is this possible?
> >
> >
> > --
> > Marcin S.
>
>|||assuming you have a vpn connection established to get you on the local LAN:
tcp:192.168.0.150,1434
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
news:6914E943-4C67-43D9-A094-E4060570AFF4@.microsoft.com...
> Hi,
> I'm running two instances om the MSSQL server och they have differnt ports
> 1434 and 1435
> I want to remotly to connect to 192.168.0.150:1434 and/or
> 192.168.0.150:1435
> the both servers are on separeta DMZ and the SQL connection passing thru
> an
> Firewall. I can telnet to this ports so the fire wall is working correct
> by i
> dont know how to specify a port in QA an in the connection string.
>
> --
> Marcin S.
>
> "Kevin3NF" wrote:
>> You can only connect through the port SQL Server is listening on...are
>> you
>> wanting to change the port at the server level?
>> --
>> Kevin Hill
>> President
>> 3NF Consulting
>> www.3nf-inc.com/NewsGroups.htm
>> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
>> www.experts-exchange.com - experts compete for points to answer your
>> questions
>>
>> "Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
>> news:6FD75159-C14C-435C-880C-435CA35C2818@.microsoft.com...
>> > Hi,
>> >
>> > Im trying to access MSSQL 2000 instance on diffrent port using Query
>> > analyzer
>> > is this possible?
>> >
>> >
>> > --
>> > Marcin S.
>>|||No there is no VPN the SQL server is just separated from the webserver by a
firewall.
--
Marcin S.
"Kevin3NF" wrote:
> assuming you have a vpn connection established to get you on the local LAN:
> tcp:192.168.0.150,1434
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
> news:6914E943-4C67-43D9-A094-E4060570AFF4@.microsoft.com...
> > Hi,
> >
> > I'm running two instances om the MSSQL server och they have differnt ports
> >
> > 1434 and 1435
> >
> > I want to remotly to connect to 192.168.0.150:1434 and/or
> > 192.168.0.150:1435
> > the both servers are on separeta DMZ and the SQL connection passing thru
> > an
> > Firewall. I can telnet to this ports so the fire wall is working correct
> > by i
> > dont know how to specify a port in QA an in the connection string.
> >
> >
> > --
> > Marcin S.
> >
> >
> > "Kevin3NF" wrote:
> >
> >> You can only connect through the port SQL Server is listening on...are
> >> you
> >> wanting to change the port at the server level?
> >>
> >> --
> >> Kevin Hill
> >> President
> >> 3NF Consulting
> >>
> >> www.3nf-inc.com/NewsGroups.htm
> >>
> >> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> >>
> >> www.experts-exchange.com - experts compete for points to answer your
> >> questions
> >>
> >>
> >> "Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
> >> news:6FD75159-C14C-435C-880C-435CA35C2818@.microsoft.com...
> >> > Hi,
> >> >
> >> > Im trying to access MSSQL 2000 instance on diffrent port using Query
> >> > analyzer
> >> > is this possible?
> >> >
> >> >
> >> > --
> >> > Marcin S.
> >>
> >>
> >>
>
>|||Hi,
this is almost working but i think i must specify the instance how to do tha
192.168.0.150\MSSQL2,1435 '
My instancename is MSSQL1 and MSSQL2
Marcin S.
"Kevin3NF" wrote:
> assuming you have a vpn connection established to get you on the local LAN:
> tcp:192.168.0.150,1434
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
> news:6914E943-4C67-43D9-A094-E4060570AFF4@.microsoft.com...
> > Hi,
> >
> > I'm running two instances om the MSSQL server och they have differnt ports
> >
> > 1434 and 1435
> >
> > I want to remotly to connect to 192.168.0.150:1434 and/or
> > 192.168.0.150:1435
> > the both servers are on separeta DMZ and the SQL connection passing thru
> > an
> > Firewall. I can telnet to this ports so the fire wall is working correct
> > by i
> > dont know how to specify a port in QA an in the connection string.
> >
> >
> > --
> > Marcin S.
> >
> >
> > "Kevin3NF" wrote:
> >
> >> You can only connect through the port SQL Server is listening on...are
> >> you
> >> wanting to change the port at the server level?
> >>
> >> --
> >> Kevin Hill
> >> President
> >> 3NF Consulting
> >>
> >> www.3nf-inc.com/NewsGroups.htm
> >>
> >> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> >>
> >> www.experts-exchange.com - experts compete for points to answer your
> >> questions
> >>
> >>
> >> "Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
> >> news:6FD75159-C14C-435C-880C-435CA35C2818@.microsoft.com...
> >> > Hi,
> >> >
> >> > Im trying to access MSSQL 2000 instance on diffrent port using Query
> >> > analyzer
> >> > is this possible?
> >> >
> >> >
> >> > --
> >> > Marcin S.
> >>
> >>
> >>
>
>|||192.168.0.150\MSSQL2,1435 is correct.
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
news:4818A5FC-FE43-4C54-ABF9-25FA67B4C23D@.microsoft.com...
> Hi,
> this is almost working but i think i must specify the instance how to do
> tha
> 192.168.0.150\MSSQL2,1435 '
> My instancename is MSSQL1 and MSSQL2
>
> --
> Marcin S.
>
> "Kevin3NF" wrote:
>> assuming you have a vpn connection established to get you on the local
>> LAN:
>> tcp:192.168.0.150,1434
>> --
>> Kevin Hill
>> President
>> 3NF Consulting
>> www.3nf-inc.com/NewsGroups.htm
>> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
>> www.experts-exchange.com - experts compete for points to answer your
>> questions
>>
>> "Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
>> news:6914E943-4C67-43D9-A094-E4060570AFF4@.microsoft.com...
>> > Hi,
>> >
>> > I'm running two instances om the MSSQL server och they have differnt
>> > ports
>> >
>> > 1434 and 1435
>> >
>> > I want to remotly to connect to 192.168.0.150:1434 and/or
>> > 192.168.0.150:1435
>> > the both servers are on separeta DMZ and the SQL connection passing
>> > thru
>> > an
>> > Firewall. I can telnet to this ports so the fire wall is working
>> > correct
>> > by i
>> > dont know how to specify a port in QA an in the connection string.
>> >
>> >
>> > --
>> > Marcin S.
>> >
>> >
>> > "Kevin3NF" wrote:
>> >
>> >> You can only connect through the port SQL Server is listening on...are
>> >> you
>> >> wanting to change the port at the server level?
>> >>
>> >> --
>> >> Kevin Hill
>> >> President
>> >> 3NF Consulting
>> >>
>> >> www.3nf-inc.com/NewsGroups.htm
>> >>
>> >> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area
>> >> DBAs.
>> >>
>> >> www.experts-exchange.com - experts compete for points to answer your
>> >> questions
>> >>
>> >>
>> >> "Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
>> >> news:6FD75159-C14C-435C-880C-435CA35C2818@.microsoft.com...
>> >> > Hi,
>> >> >
>> >> > Im trying to access MSSQL 2000 instance on diffrent port using Query
>> >> > analyzer
>> >> > is this possible?
>> >> >
>> >> >
>> >> > --
>> >> > Marcin S.
>> >>
>> >>
>> >>
>>

Access MSDE instance remotely

I have a named instance of MSDE running on my windows 2k3 web server. I can connect just fine using ODBC to that DB whailst I am on the server.

I would like to be able to create an ODBC connection from my local machine (running Windows XP pro) to the MSDE database on my server but I can't get it going.

I have heard that I need to edit the registry but a Google search warns that this could be a vulnerability...

How do I do it without compromising the security of my web server?

TIAMostly, when you install MSDE by default settings, net library are not installed. Have a look to the Readme.html, or install Network client ton activate Named pipes or TCP/IP.|||I have the SQL server network utility installed as I can see it when I use the command svrnetcn.exe

Do I need to add a new pipe? I'm a noob at this sort of thing I'm afraid so an idiot proof answer will probably be needed! :D|||Next to what you said above, it seems that there is no net library installed. So install Named pipes and TCP/IP. Confirm, and try aggain to connect to the named instance from your machine.|||I'm sorry but I don't follow you. How do I do this?|||ok progress "I think"

I'm now connecting to the server but I get this:
http://www.openmindhosting.com/odbc.jpg

I'm using the same login I use for RDC connections to the server so I know its the admin account...|||Good ! Now, I think the problem is the authentication (I can see login failed for 'Administrator').

Try to use the account sa with its password (you must have configured it at install). If not, it must be empty (that is a bad thing :D )|||ok I finally managed to login through ODBC. I had to log off on my local machine and then logon using the same username and password as the server. I then adjusted the ODBC connection so that it used windows authentication and itc reated the datasource!

Marvellous I thought! :)

Logged back off and then back on as my normal user, which is also an admin account and then tried to set the datasource in the ColdFusion adminstrator and was told it was not a trusted connection for user NULL. Grrrrrrr :mad:|||So, good ! :)|||It would be if I didn't want to use CF to connect to the database! ;)

I'll figure it out... Thanks for your help...|||Sorry, I don't know how ineract Coldfusion with SQL. Maybe you would ask to r937 (http://www.dbforums.com/member.php?u=7592) ? I think he knows CF !

Access is denied: 'Microsoft.Samples.ReportingServices.CustomSecur

I am installing Reporting Services on a Veritas cluster environment on a
named Instance of SQL Server. The installation seems to go OK, but
afterwards when I try to call up the ReportManager I get this error:
Access is denied: 'Microsoft.Samples.ReportingServices.CustomSecurity'
I'm using a Domain Account with administrator privlidges, so I'm not sure
what to do next? Can anyone help?
thanksHere, I think, your report manager is somehow refering to custom
security extension which is configured in configuration files. Please
check if ur RM is pointing to proper server.
Thanks,
Mahesh

Access is denied. [0x80070005]

Hi frnds,

I am having a SQL 2005 instance on win2003 server.

SQL Server 2005, Standard Edition with SP1
Windows Server 2003, Standard Edition with SP1

2 days back, all services went down and I was not able to see anything in logs,how they went down? I restarted all the SQL Services again thru services.msc but when I am trying to open 'SQL Server Configuration Manager'.... .I am getting this error...

Cannot connect to WMI provider.You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 servers with SQL Server Configuration Manager.
Access is denied. [0x80070005]

I googled and got some good links about this error...
1 - http://www.sql- server-performan ce.com/faq/ sqlviewfaq. aspx?faqid= 296

2 - http://forums. microsoft. com/MSDN/ ShowPost. aspx?PostID= 142375&SiteID= 1

3 - http://www.ocforums .com/showthread. php?t=482307

I followed but didn't get success...has someone faced this issue and resolved also plz guide me......

And one more thing......sql services are running on this machine 'A' but Start, Stop, Pause, Resume and Restart option are not highlighted on this instance. I connected one another instance 'B' on this machine and got same issue (options were not highlighted) but when I opened that perticular machine where that instance 'B' is installed, i was able to see all option runable so i registered that instance 'A' on 'B' machine and got here also I was not able to see these option highlighted only for 'A'...

Please help me....a lot of thanks to all of you...

Thanks & Regards,
Mohd Rizwan

frnds...

finally I got success to resolve my issue.....first I run this command thru command prompt....

secedit /configure /cfg %windir%\repair\secsetup.inf /db secsetup.sdb /verbose

then re-started the windows and then run this command from command prompt....

C:\Program Files\Microsoft SQL Server\90\Shared>mofcomp "C:\Program Files\Microsoft SQL Server\90\Shared\sqlmgmproviderxpsp2up.mof"

I got this idea thru this link..
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1721211&SiteID=1

Thanks you.........

Rizwan................

Access is denied. [0x80070005]

Hi frnds,

I am having a SQL 2005 instance on win2003 server.

SQL Server 2005, Standard Edition with SP1
Windows Server 2003, Standard Edition with SP1

2 days back, all services went down and I was not able to see anything in logs,how they went down? I restarted all the SQL Services again thru services.msc but when I am trying to open 'SQL Server Configuration Manager'.... .I am getting this error...

Cannot connect to WMI provider.You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 servers with SQL Server Configuration Manager.
Access is denied. [0x80070005]

I googled and got some good links about this error...
1 - http://www.sql- server-performan ce.com/faq/ sqlviewfaq. aspx?faqid= 296

2 - http://forums. microsoft. com/MSDN/ ShowPost. aspx?PostID= 142375&SiteID= 1

3 - http://www.ocforums .com/showthread. php?t=482307

I followed but didn't get success...has someone faced this issue and resolved also plz guide me......

And one more thing......sql services are running on this machine 'A' but Start, Stop, Pause, Resume and Restart option are not highlighted on this instance. I connected one another instance 'B' on this machine and got same issue (options were not highlighted) but when I opened that perticular machine where that instance 'B' is installed, i was able to see all option runable so i registered that instance 'A' on 'B' machine and got here also I was not able to see these option highlighted only for 'A'...

Please help me....a lot of thanks to all of you...

Thanks & Regards,
Mohd Rizwan

Hi,

by using the The WMI Diagnosis Utility it will give your more information about your WMI provider

BTW, what about installing the client tools on another box?

|||

Thanks to reply....

finally I got success to resolve my issue.....first I run this command thru command prompt....

secedit /configure /cfg %windir%\repair\secsetup.inf /db secsetup.sdb /verbose

then re-started the windows and then run this command from command prompt....

C:\Program Files\Microsoft SQL Server\90\Shared>mofcomp "C:\Program Files\Microsoft SQL Server\90\Shared\sqlmgmproviderxpsp2up.mof"

I got this idea thru this link..
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1721211&SiteID=1

Thanks once again for your kind help...

Access is Denied in Upgrade Advisor

Hi all,

I have run the SQL Server 2005 Upgrade Advisor against a default instance of SQL Server 2000 server running on Windows Server 2003.

One thing I need to fix before I upgrade is:

Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)

SVCACCTREQ

I'm not sure what this means or what I need to do before I can upgrade.

Does anyone have a clue on this one.

Thanks,

David

Hi David,

The issue you posted is actually an error encountered while processing the rule (SVCACCTREQ). I'm wondering if the account you used to run Upgrade Advisor was a member of the local administrators group on the machine in question?

jeff.

|||

Thanks Jeff,

I am running the Upgrade Advisor remotely as the server does not have .NET 2.0 Framework installed.

The first time I got the error, I connected to SQL Server using TCP/IP logging on as sa.

I got the same result where I had a mapped drive to the remote server using a Domain Administrator logon and use Named Pipes to connect to SQL Server.

We now have access to a test server where I can install the .NET 2.0 Framework and run the Upgrade Advisor locally.

Hopefully this will resolve the problem.

David.

|||

Jeff, same here using SA (remote).

I also get "Attempted to perform an unauthorized operation" on NETPROTOCOL, MDACVERSION and few more.

\Ruud

|||

Is there anyway to use the Upgrade Advisor tool remotely avoiding the .net framework installation on sql server 200?

i got the following errors:

Attempted to perform an unauthorized operation.
Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))

Thanks

Gianfranco

|||Some of the rules executed by Upgrade Advisor require admin priviliages at the Operating System layer that won't be available when using SQL Authentication. I suspect the rules you are encountering these errors are those rules which require admin priviliages at the Operating System layer. The SA, or equivilant SQL account, does not have permission to perform the actions necessary for these rules to execute, thus the error you are seeing.|||

You should not need to install the .NET Framework on a remote install. All rules will use either a SQL Connection or WMI to perform the action requested by the rule. The .NET Framework is a requirement of the Upgrade Advisor tool itself, so only where you are running Upgrade Advisor do you need the .NET Framework.

There are additional requirements for the Upgrade Advisor client machine, such as OLAP Tools and the DTS client, so make sure you have those installed on the machine where you're Upgrade Advisor.

|||

I was trying to do the remote installation too and I got the same error too.

I was able to fix this by running Sql Server 2005 Upgrade Advisor on a machine that was on the same domain as the database server.

I was logged in as a user who had administrator rights on both machines. So when I ran Sql Server 2005 Upgrade Advisor I made it connect to the database server and to login using Windows Authentication.

Access is Denied in Upgrade Advisor

Hi all,

I have run the SQL Server 2005 Upgrade Advisor against a default instance of SQL Server 2000 server running on Windows Server 2003.

One thing I need to fix before I upgrade is:

Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)

SVCACCTREQ

I'm not sure what this means or what I need to do before I can upgrade.

Does anyone have a clue on this one.

Thanks,

David

Hi David,

The issue you posted is actually an error encountered while processing the rule (SVCACCTREQ). I'm wondering if the account you used to run Upgrade Advisor was a member of the local administrators group on the machine in question?

jeff.

|||

Thanks Jeff,

I am running the Upgrade Advisor remotely as the server does not have .NET 2.0 Framework installed.

The first time I got the error, I connected to SQL Server using TCP/IP logging on as sa.

I got the same result where I had a mapped drive to the remote server using a Domain Administrator logon and use Named Pipes to connect to SQL Server.

We now have access to a test server where I can install the .NET 2.0 Framework and run the Upgrade Advisor locally.

Hopefully this will resolve the problem.

David.

|||

Jeff, same here using SA (remote).

I also get "Attempted to perform an unauthorized operation" on NETPROTOCOL, MDACVERSION and few more.

\Ruud

|||

Is there anyway to use the Upgrade Advisor tool remotely avoiding the .net framework installation on sql server 200?

i got the following errors:

Attempted to perform an unauthorized operation.
Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))

Thanks

Gianfranco

|||Some of the rules executed by Upgrade Advisor require admin priviliages at the Operating System layer that won't be available when using SQL Authentication. I suspect the rules you are encountering these errors are those rules which require admin priviliages at the Operating System layer. The SA, or equivilant SQL account, does not have permission to perform the actions necessary for these rules to execute, thus the error you are seeing.|||

You should not need to install the .NET Framework on a remote install. All rules will use either a SQL Connection or WMI to perform the action requested by the rule. The .NET Framework is a requirement of the Upgrade Advisor tool itself, so only where you are running Upgrade Advisor do you need the .NET Framework.

There are additional requirements for the Upgrade Advisor client machine, such as OLAP Tools and the DTS client, so make sure you have those installed on the machine where you're Upgrade Advisor.

|||

I was trying to do the remote installation too and I got the same error too.

I was able to fix this by running Sql Server 2005 Upgrade Advisor on a machine that was on the same domain as the database server.

I was logged in as a user who had administrator rights on both machines. So when I ran Sql Server 2005 Upgrade Advisor I made it connect to the database server and to login using Windows Authentication.

Access is Denied

I installed an instance of MSDE when I try to start the instance I get "Access is Denied".

Any Ideas?did you install it as an administrator, and you're logging in as a user?|||Yes, I installed it under the admin account I am logging in as admin.

Thanks, Justin.|||Did you follow the instructions?

I've yet to experience any failed installs of msde.. Did you select anything specific or create an sa account?|||Yes, I followed the readme instructions. I used a command prompt with this command: setup INSTANCENAME="InstanceName" SAPWD="AStrongSAPwd"|||is the service not starting? or are you unable to log in to it?|||When I try to start the MSDE from the sql service manager I get the following error:
"This service control action can not be completed as no service has been selected"

There are no services in the services drop down.|||... Um.

The Server: is your computer name right? and you clicked Refresh Services...?

Access Denied when connecting

I am having a problem connecting to my SQL 2005 named instance on a clustered
server in another domaim. If I am within the domain everything works fine. If
I am in a different domain, I cannot register it through SQL Management
Studio or create an ODBC connection. I can ping it and all of the cluster
nodes. When trying to connect I get the following errors:
SQL Management Studio:
"An error has occured while establishing a connection to the server. When
connecting to SAL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.
(provider:SQL Network Interfaces, error:26 -Error locating server/instance
specified)
ODBC:
SQL Server Error: 17
ODBC SQL Server Driver SQL Server does not exist or access denied
However, the server is set up for remote connections.
Any Suggestions?
What type of authentication are you using Windows or SQL?
If you are using SQL login, you should be able to connect as long as you can
ping the server. Since your SQL server is on a different Domain, and you
want to use your Windows domain account, make sure that you have a trust
relationship between the 2 domains if you login to one domain and want to
access the other one.
Ayad Shammout
"Rick" <Rick@.discussions.microsoft.com> wrote in message
news:BAD23A07-CEB4-4A33-BC0C-2B5C61602812@.microsoft.com...
>I am having a problem connecting to my SQL 2005 named instance on a
>clustered
> server in another domaim. If I am within the domain everything works fine.
> If
> I am in a different domain, I cannot register it through SQL Management
> Studio or create an ODBC connection. I can ping it and all of the cluster
> nodes. When trying to connect I get the following errors:
> SQL Management Studio:
> "An error has occured while establishing a connection to the server. When
> connecting to SAL Server 2005, this failure may be caused by the fact that
> under the default settings SQL Server does not allow remote connections.
> (provider:SQL Network Interfaces, error:26 -Error locating server/instance
> specified)
> ODBC:
> SQL Server Error: 17
> ODBC SQL Server Driver SQL Server does not exist or access denied
> However, the server is set up for remote connections.
> Any Suggestions?