Instances list on remote IP

Is there a way to get all the SQL Server instances with SQL SMO from a
remote computer?
I got few instances on some remote IP and
how to list them, how to pass to the function this address - could it be
done at all?
Second question:
Locally I'm using SmoApplication.EnumAvailableSqlServers, but
I've got SQLEXPRESS and MSDE SP 4, and got MYCOMPUTERNAME\SQLEXPRESS and
MYCOMPUTERNAME\MSDE2000 but if I do that:
DataTable dt = SmoApplication.EnumAvailableSqlServers(false);
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
ddlSQLServerInstances.Items.Add(new
ListItem(dr["Name"].ToString(), dr["Name"].ToString()));
}
}
In my dropdownlist appears only MYCOMPUTERNAME, nothing more...
I'll be happy for any suggestions.
Thank you!!!I had the same problem and it turned out to be that the firewall is blocking
the packets. I think one needs to have UDP 1343 open outbound, but unless I
turn off the firewall I still do not get non-local server instances in the
enumeration; The data seems to be sent back on random UDP ports > 2700, (th
e
port range is not confirmed) and I'm not sure if one can specify ranges usin
g
the built-in Windows XP SP2 firewall.
If anyone has a solution for this that lets me use the same firewall and
still get the enumeration, please reply. I'm curious.
"christof" wrote:

> Is there a way to get all the SQL Server instances with SQL SMO from a
> remote computer?
> I got few instances on some remote IP and
> how to list them, how to pass to the function this address - could it be
> done at all?
> Second question:
> Locally I'm using SmoApplication.EnumAvailableSqlServers, but
> I've got SQLEXPRESS and MSDE SP 4, and got MYCOMPUTERNAME\SQLEXPRESS and
> MYCOMPUTERNAME\MSDE2000 but if I do that:
> DataTable dt = SmoApplication.EnumAvailableSqlServers(false);
> if (dt.Rows.Count > 0)
> {
> foreach (DataRow dr in dt.Rows)
> {
> ddlSQLServerInstances.Items.Add(new
> ListItem(dr["Name"].ToString(), dr["Name"].ToString()));
> }
> }
> In my dropdownlist appears only MYCOMPUTERNAME, nothing more...
> I'll be happy for any suggestions.
> Thank you!!!
>

Installing SQL Server on a remote server?

Hi,
I have SQL Server 2005 on 2 CDs. I need to install it on a remote server,
but I can't access in person the server, since it's several hundreds miles
away, so i can't put the CD in.
Is there a trick to install SQL Server on a remote server without having to
put the CD in the CD drive? I searched but I still haven't found the right
answer.
Thanks
StephaneOf course you can install SQL Server on that server as long as you have a
network connection and the local Administrator permissions needed to do the
installation.
You can share the CD from a local computer or you can just copy the CD files
to the remote server.
Hope this helps,
Ben Nevarez
"Stephane" wrote:
> Hi,
> I have SQL Server 2005 on 2 CDs. I need to install it on a remote server,
> but I can't access in person the server, since it's several hundreds miles
> away, so i can't put the CD in.
> Is there a trick to install SQL Server on a remote server without having to
> put the CD in the CD drive? I searched but I still haven't found the right
> answer.
> Thanks
> Stephane|||Hi,
Thanks for your answer. If by network connection you mean a LAN, no I don't
have that. The only access I got is by Remote Desktop. And of course, I have
all admin access.
That's the Remote Desktop installation the problem. Can I upload all the CD
files to the server and execute them? Is there a downloadable version (not
the trial) on microsoft.com?
Thanks,
Stephane
"Ben Nevarez" wrote:
> Of course you can install SQL Server on that server as long as you have a
> network connection and the local Administrator permissions needed to do the
> installation.
> You can share the CD from a local computer or you can just copy the CD files
> to the remote server.
> Hope this helps,
> Ben Nevarez
>
>
> "Stephane" wrote:
> > Hi,
> >
> > I have SQL Server 2005 on 2 CDs. I need to install it on a remote server,
> > but I can't access in person the server, since it's several hundreds miles
> > away, so i can't put the CD in.
> >
> > Is there a trick to install SQL Server on a remote server without having to
> > put the CD in the CD drive? I searched but I still haven't found the right
> > answer.
> >
> > Thanks
> >
> > Stephane|||If you can get to it via Remote Desktop, you have network connection. Remote
Desktop to that server, and map a map to the wherever the SQL Server CD is.
You can either install off the network mapped drive directly or copy the CD
content to a local dirve on the machine itself before running SQL Server
Setup.
For any server in a datacenter, these days it's very rare that anybody would
really walk to the server to do any install. So it doesn't matter whether the
machine is afew hundred miles away or in a different room on the same floor,
the install is done remotely (often via Remote Desktop).
Linchi
"Stephane" wrote:
> Hi,
> Thanks for your answer. If by network connection you mean a LAN, no I don't
> have that. The only access I got is by Remote Desktop. And of course, I have
> all admin access.
> That's the Remote Desktop installation the problem. Can I upload all the CD
> files to the server and execute them? Is there a downloadable version (not
> the trial) on microsoft.com?
> Thanks,
> Stephane
> "Ben Nevarez" wrote:
> >
> > Of course you can install SQL Server on that server as long as you have a
> > network connection and the local Administrator permissions needed to do the
> > installation.
> >
> > You can share the CD from a local computer or you can just copy the CD files
> > to the remote server.
> >
> > Hope this helps,
> >
> > Ben Nevarez
> >
> >
> >
> >
> > "Stephane" wrote:
> >
> > > Hi,
> > >
> > > I have SQL Server 2005 on 2 CDs. I need to install it on a remote server,
> > > but I can't access in person the server, since it's several hundreds miles
> > > away, so i can't put the CD in.
> > >
> > > Is there a trick to install SQL Server on a remote server without having to
> > > put the CD in the CD drive? I searched but I still haven't found the right
> > > answer.
> > >
> > > Thanks
> > >
> > > Stephane|||Hum... It seems obvious that the tech guy stay at his computer to do a
installation. But the question is « how »! ;-)
I tried to map a network drive from the Win 2003 server to my XP computer
but I couldn't get it to work. I can't ping my computer from the server even
though I disabled all the firewalls.
Any idea how to map a drive from a win 2003 server to a XP computer via the
IP address?
Thanks
Stephane
"Linchi Shea" wrote:
> If you can get to it via Remote Desktop, you have network connection. Remote
> Desktop to that server, and map a map to the wherever the SQL Server CD is.
> You can either install off the network mapped drive directly or copy the CD
> content to a local dirve on the machine itself before running SQL Server
> Setup.
> For any server in a datacenter, these days it's very rare that anybody would
> really walk to the server to do any install. So it doesn't matter whether the
> machine is afew hundred miles away or in a different room on the same floor,
> the install is done remotely (often via Remote Desktop).
> Linchi
> "Stephane" wrote:
> > Hi,
> >
> > Thanks for your answer. If by network connection you mean a LAN, no I don't
> > have that. The only access I got is by Remote Desktop. And of course, I have
> > all admin access.
> >
> > That's the Remote Desktop installation the problem. Can I upload all the CD
> > files to the server and execute them? Is there a downloadable version (not
> > the trial) on microsoft.com?
> >
> > Thanks,
> >
> > Stephane
> >
> > "Ben Nevarez" wrote:
> >
> > >
> > > Of course you can install SQL Server on that server as long as you have a
> > > network connection and the local Administrator permissions needed to do the
> > > installation.
> > >
> > > You can share the CD from a local computer or you can just copy the CD files
> > > to the remote server.
> > >
> > > Hope this helps,
> > >
> > > Ben Nevarez
> > >
> > >
> > >
> > >
> > > "Stephane" wrote:
> > >
> > > > Hi,
> > > >
> > > > I have SQL Server 2005 on 2 CDs. I need to install it on a remote server,
> > > > but I can't access in person the server, since it's several hundreds miles
> > > > away, so i can't put the CD in.
> > > >
> > > > Is there a trick to install SQL Server on a remote server without having to
> > > > put the CD in the CD drive? I searched but I still haven't found the right
> > > > answer.
> > > >
> > > > Thanks
> > > >
> > > > Stephane|||"Stephane" <Stephane@.discussions.microsoft.com> wrote in message
news:B60E6D27-0831-43D6-B924-29920E41449C@.microsoft.com...
> Hum... It seems obvious that the tech guy stay at his computer to do a
> installation. But the question is « how »! ;-)
>
Trying to map a drive assumes that the firewall will let through
windows-networking (not always the case)
A common way to to use a tool like WinZIP or WinRAR
(http://www.rarsoft.com/) and then temporarily move the files via an FTP
site that both systems can access
(You may find that the remote system is itself an FTP Server)
Rather than trying to copy 700+Mb in one go, by using WinRAR you can cut the
CD down into "manageable" slices (e.g. 25Mb each)
Then, unpack the files to a folder on the remote PC, and run "setup" from
there.
--
Depending on the options that you choose, there is a good chance that you
won't need CD2 (or all of files on CD1)
(e.g. choice between x86 and x64 versions may mean that you can ignore a lot
of files)
Steven|||The suggestion od sending the files via RDP seems to be a slow time
consuming action, not always a reliable way.
Why not just send the CDs by real post instead an perform the install
tomorrow or the day after that instead?
--
Henrik Arenblad, MCP SBS,
"Steven Wilmot" <steven-news@.data-utilities.co.uk> wrote in message
news:47b05e8a$0$511$5a6aecb4@.news.aaisp.net.uk...
> "Stephane" <Stephane@.discussions.microsoft.com> wrote in message
> news:B60E6D27-0831-43D6-B924-29920E41449C@.microsoft.com...
>> Hum... It seems obvious that the tech guy stay at his computer to do a
>> installation. But the question is « how »! ;-)
> Trying to map a drive assumes that the firewall will let through
> windows-networking (not always the case)
> A common way to to use a tool like WinZIP or WinRAR
> (http://www.rarsoft.com/) and then temporarily move the files via an FTP
> site that both systems can access
> (You may find that the remote system is itself an FTP Server)
> Rather than trying to copy 700+Mb in one go, by using WinRAR you can cut
> the CD down into "manageable" slices (e.g. 25Mb each)
> Then, unpack the files to a folder on the remote PC, and run "setup" from
> there.
> --
> Depending on the options that you choose, there is a good chance that you
> won't need CD2 (or all of files on CD1)
> (e.g. choice between x86 and x64 versions may mean that you can ignore a
> lot of files)
> Steven
>

Installing SQL Server Express 2005 via Remote Desktop

Hi,

Does anyone know if it's at all possible to install SQL Server Express 2005 over a Remote Desktop on a Windows XP machine.

I know there are problems running SQL over Remote Desktop, in that it won't start up a User Instance, but I wasn't sure if we can install over Remote Desktop.

If it's not possible, can anyone point me to an official document stating this fact?

Thanks

Sam

Yes, this is most certainly possible. If you encounter an error during install, please share the logs (%ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\Log)so we can take a look.|||

Hi Jeff,

I've just been able to confirm that installing SQL via Remote Desktop is possible.

Our application requires user instances, and so after installation I then tried running our application via Remote Desktop. However, it came up with an exception "Failed to generate a user instance of SQL Server..."

I then went directly onto the remote machine and ran our application, and it worked perfectly fine.

So remote installation was fine, but running remotely with user instances is a problem.

Thanks
Sam

Integrated Authentication not working for remote datasources.

Hi,

I'm having problems getting integrated authentication to work when a datasource points to a database on a remote server.

Here's an example of what I'm using for a connection string:

Data Source=<server>;Initial Catalog=<database>

When I try to run a report w/ Integrated Authentication checked, I get the following error:

An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'VistaGlobal'. (rsErrorOpeningConnection)

For more information about this error navigate to the report server on the local server machine, or enable remote errors.

The following is logged on the remote server where the datasource points to:

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

I can't figure one why it's logging in anonymously when I'm running the report from Report manager. It works when I explicitly supply my user login but doesn't work w/ integrated authentication. Also, the report will run fine if I point the datasource to a database on the report server. Any help is appreciated.

Thanks,

Henry

Figured it out... I have to enable IIS to use Kerberos authentication.

Here's the KB article that I followed: 326089

Installing sql 2005 using RDP.

Are there any known issues (problems, etc.) with installing sql 2005 on a remote server using Remote Desktop? Any problems installing Sql 2005 SP1 via RDP?

TIA,

Barkingdog

We (the SQL Server setup test team) heavily rely on remote desktop in our testing and I've never run into any issues.

Thanks,
Sam Lester (MSFT)

Installing SQL 2000 RS

We are installing SQL 2000 RS Standard Edition on a server running Windows
2003 Server. We want to place the Reporting Services database on a Remote
instance of SQL Server 2000 Standard Edition running on a server with Windows
2003 Server.
We get to the database setup and receive a 1603 error that it cannot
configure the database because the user [NULL] is not a recognized SQL login.
We tried several different accounts just to trouble-shoot but with no
success. The account running the setup is a local admin and a SQL admin and
can connect to the SQL instance just fine.
I would appreciate any suggestions that you can pass on.
Thank You, -bertDoes the machine uses Kerberos? Becasue that's necessary if you want to
transport the Windows Accountinformation
"-bert" wrote:
> We are installing SQL 2000 RS Standard Edition on a server running Windows
> 2003 Server. We want to place the Reporting Services database on a Remote
> instance of SQL Server 2000 Standard Edition running on a server with Windows
> 2003 Server.
> We get to the database setup and receive a 1603 error that it cannot
> configure the database because the user [NULL] is not a recognized SQL login.
> We tried several different accounts just to trouble-shoot but with no
> success. The account running the setup is a local admin and a SQL admin and
> can connect to the SQL instance just fine.
> I would appreciate any suggestions that you can pass on.
> Thank You, -bert|||Thank you Koen;
We just finished working with Rajan from Microsoft. We ended up
uninstalling Terminal Services completely and the install went smoothly. We
then reinstalled TS and it seems fine. Disabling TS worked fine when we
installed it all on one server.
Now it keeps asking us to login over and over...that is the next problem
to solve.
Thank you, -bert
"Koen" wrote:
> Does the machine uses Kerberos? Becasue that's necessary if you want to
> transport the Windows Accountinformation
> "-bert" wrote:
> > We are installing SQL 2000 RS Standard Edition on a server running Windows
> > 2003 Server. We want to place the Reporting Services database on a Remote
> > instance of SQL Server 2000 Standard Edition running on a server with Windows
> > 2003 Server.
> > We get to the database setup and receive a 1603 error that it cannot
> > configure the database because the user [NULL] is not a recognized SQL login.
> > We tried several different accounts just to trouble-shoot but with no
> > success. The account running the setup is a local admin and a SQL admin and
> > can connect to the SQL instance just fine.
> > I would appreciate any suggestions that you can pass on.
> >
> > Thank You, -bert