Remotely installing DSN

Is there any way to install a System DSN to all the pcs on my 2003 network?
(clients running xp)
either by a GPO or something else?]
i dont want to have to go around every pc doing itSystem DSN's are stored in the registry. making it somewhat difficult to
distribute.
You could change ther registry on one computer, save the registry to .reg
file, distrubute to all computers, and execute a custom script to import the
value.
ODBC entries are located in the registry in two spots. Both are under the
HKEY_Local_Machine\Software\ODBC
The first is found in the ODBC Data Sources subkey
The second set of registry entries go in the ODBC.INI subkey.
there are applications to help you do this as well...
http://www.freevbcode.com/ShowCode.asp?ID=3369
If it was me I would try my hardest to change the Datasource on the
application level before changing alot of computers.
--
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
*/
"MatthewWilsonAPD" <MatthewWilsonAPD@.discussions.microsoft.com> wrote in
message news:2DF39EDF-40A9-4FAB-9E72-7BEB554A7FAA@.microsoft.com...
> Is there any way to install a System DSN to all the pcs on my 2003
> network?
> (clients running xp)
> either by a GPO or something else?]
> i dont want to have to go around every pc doing it|||DSNs are just registry entries so you could create a
VBScript to deploy or call from login scripts...whichever.
Take a look at the following example:
http://www.databasejournal.com/feat...cle.php/2238221
-Sue
On Fri, 8 Sep 2006 08:24:02 -0700, MatthewWilsonAPD
<MatthewWilsonAPD@.discussions.microsoft.com> wrote:

>Is there any way to install a System DSN to all the pcs on my 2003 network?
>(clients running xp)
>either by a GPO or something else?]
>i dont want to have to go around every pc doing it

Remote tools install error

I am trying to install SQL server 2000 client tools on to a Win 2000 server.
I get an install error
' installation of MS data access components failed (-).
My server is service pack 3. I understand that that Win 2 K service pack 3
installs MDAC 2.5 SP3.
My MDAC version is 2.53.6200.1
Has anyone seen this error before and is there a fix for getting the client
tools install to work?
Thanks.
JTThanks for your replies. My struggle continues.
I was able to run sqlsetup in debug mode and installed all other client tool
components other than mdac.
I ran mdac component checker to confirm that I am running mdac version 2.5
SP3 - no conflicts seen with the component checker.
I tried to install mdac 6 from the SQL server disk, but the install appeared
to do nothing.
I downloaded mdac 2.6 SP1 and tried to install it but it failed.
I tried to uninstall the sql tools install but it fails with msg ' internal
error - unable to load or call an external .dll
I have tried to reinstall the tools through the setup maintenance mode. It
appears to install a few files and then finishes, but I can't get in to
Enterprise Mgr or any of the other tools.
I deleted the ExceptionComponents reg key, and attempted to reinstall, but I
am getting nowhere with that.
I am trying to install this on a W2K server w/ terminal services running. I
stopped the terminal services service and tried again to install, but I am
not making any progress with that either.
So how does one uninstall these client tools and start over?
Thanks.
"Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
news:ugUwZspZDHA.2032@.TK2MSFTNGP10.phx.gbl...
> Jane,
> I have listed some options in..
> Q: "Installation of the Microsoft Data Access Components package failed.
> (-1)"-- Error occurs during setup ?
> http://www.tkdinesh.com/faq/ans/MDACerr.html
>
> --
> Dinesh.
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Jane Tunnicliff" <jtunn@.uwpn.org> wrote in message
> news:O41l$opZDHA.2548@.TK2MSFTNGP09.phx.gbl...
> > I am trying to install SQL server 2000 client tools on to a Win 2000
> server.
> > I get an install error
> > ' installation of MS data access components failed (-).
> >
> > My server is service pack 3. I understand that that Win 2 K service
pack
> 3
> > installs MDAC 2.5 SP3.
> > My MDAC version is 2.53.6200.1
> >
> > Has anyone seen this error before and is there a fix for getting the
> client
> > tools install to work?
> >
> > Thanks.
> >
> > JT
> >
> >
>

Remote Setup on cluster node fail

Hi,

I've tried to install SQL Server 2005 September CTP as the first named instance on a Windows Server 2003 Enterprise Edition Cluster.

During the setup process a scheduled task is created on the second cluster node, but this task is not able to run.

I received this error message in the scheduled task log file:
0x80070005: Access is denied

The user account I'm using to install SQL Server is member of the administrator on all cluster nodes, it has also the permission to log on as a service and as a batch job. The user is also permitted to access the computer from the network.

Thanks in advance for the help!

Regards,
ClausThis might be caused by a known Windows bug. Task Scheduler service fails to launch setup on a remote node even if Task Scheduler is running. If someone is logged into remote node, they risk of hitting this Windows bug. Thefore log off any Terminal Server sessions from all remote nodes before you start setup. |||Hi Yim,

Yes! That's it - i logged of from the second cluster node and the installation completes successful!

Thanks a lot!

Remote Installation of SQL server

Hi,
I was trying to install a SQL servedr remotely into another computer and
i am not sure if the "error" that i encountered was normal
I am running Win server 2003 on both PC A & B and i am using Evaluation
copy of SQL Enterprise Server
I managed to enter the remote computer's Name (e.g B) and then it prompts
me for a CD-Key which i had never encountered if i do a installation on the
local computer
Could anyone tell me where do i get the CD-Key and if this normal ?
Cheers,I have never tried to install an eval across the network, so this is just
presumption, but, the only time you are asked for a CD key is to install the
"real" thing... Perhaps the devs weren't expecting, or chose not to support
across the network install of the eval...
as a work around, try copying the CD files to the other machine, and then
use a terminal server connection to do the install locally... Maybe that
will work...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.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
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:32C379F2-B215-4948-9D5B-564AA13311E0@.microsoft.com...
> Hi,
> I was trying to install a SQL servedr remotely into another computer and
> i am not sure if the "error" that i encountered was normal
> I am running Win server 2003 on both PC A & B and i am using Evaluation
> copy of SQL Enterprise Server
> I managed to enter the remote computer's Name (e.g B) and then it
> prompts
> me for a CD-Key which i had never encountered if i do a installation on
> the
> local computer
> Could anyone tell me where do i get the CD-Key and if this normal ?
> Cheers,
>

Remote Installation of SQL server

Hi,
I was trying to install a SQL servedr remotely into another computer and
i am not sure if the "error" that i encountered was normal
I am running Win server 2003 on both PC A & B and i am using Evaluation
copy of SQL Enterprise Server
I managed to enter the remote computer's Name (e.g B) and then it prompts
me for a CD-Key which i had never encountered if i do a installation on the
local computer
Could anyone tell me where do i get the CD-Key and if this normal ?
Cheers,I have never tried to install an eval across the network, so this is just
presumption, but, the only time you are asked for a CD key is to install the
"real" thing... Perhaps the devs weren't expecting, or chose not to support
across the network install of the eval...
as a work around, try copying the CD files to the other machine, and then
use a terminal server connection to do the install locally... Maybe that
will work...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.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
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:32C379F2-B215-4948-9D5B-564AA13311E0@.microsoft.com...
> Hi,
> I was trying to install a SQL servedr remotely into another computer and
> i am not sure if the "error" that i encountered was normal
> I am running Win server 2003 on both PC A & B and i am using Evaluation
> copy of SQL Enterprise Server
> I managed to enter the remote computer's Name (e.g B) and then it
> prompts
> me for a CD-Key which i had never encountered if i do a installation on
> the
> local computer
> Could anyone tell me where do i get the CD-Key and if this normal ?
> Cheers,
>

Remote Installation of SQL server

Hi,
I was trying to install a SQL servedr remotely into another computer and
i am not sure if the "error" that i encountered was normal
I am running Win server 2003 on both PC A & B and i am using Evaluation
copy of SQL Enterprise Server
I managed to enter the remote computer's Name (e.g B) and then it prompts
me for a CD-Key which i had never encountered if i do a installation on the
local computer
Could anyone tell me where do i get the CD-Key and if this normal ?
Cheers,
I have never tried to install an eval across the network, so this is just
presumption, but, the only time you are asked for a CD key is to install the
"real" thing... Perhaps the devs weren't expecting, or chose not to support
across the network install of the eval...
as a work around, try copying the CD files to the other machine, and then
use a terminal server connection to do the install locally... Maybe that
will work...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.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
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:32C379F2-B215-4948-9D5B-564AA13311E0@.microsoft.com...
> Hi,
> I was trying to install a SQL servedr remotely into another computer and
> i am not sure if the "error" that i encountered was normal
> I am running Win server 2003 on both PC A & B and i am using Evaluation
> copy of SQL Enterprise Server
> I managed to enter the remote computer's Name (e.g B) and then it
> prompts
> me for a CD-Key which i had never encountered if i do a installation on
> the
> local computer
> Could anyone tell me where do i get the CD-Key and if this normal ?
> Cheers,
>

Remote Installation Create Response File

Hi,

Actaully i want to install SQL SERVER 2005 Enterprise edition in the silent mode and I was tyring to create a response file (setup.iss), but from the document provided i saw that SQL SERVER 2005 Enterprise edition doesnt create response file, and doesnt support setup.iss. So please provide me some solution where i can generate response file or some thing which is similar to that.

SQL 2005 now supports a ton of switches which will allow you to select all the GUI options from the command line. Check the docs on the DVD for all the options. Stick the finished command line in a batch file and use your favorite remote install tool to launch the batch file.|||

Here's the link in BOL for silent installs with a ton of examples:

http://msdn2.microsoft.com/en-us/library/ms144259.aspx

Thanks,
Sam Lester (MSFT)

remote connection problem with sql server express

Hi

have sql server express 2005 installed on a laptop running XP sp2 with IIS installed. installed sql express during the visual studio 2005 install

having problems with remote connection errors messages when using aspnet_regsql.exe as well as when trying to view pages with sql db involved. in most tests to fix this i disable my firewall, still getting error messages tho

sqlBrowser is running as is sqlexpress in services both on auto

in the surface area configuration tool, the remote connection is set to local and remote connections is using both tcp/ip and named pipes.

in sql config manager- shared memory, tcp/ip, and named pipes are enabled for both the server and the client, the order on the client is shared memory then tcp/ip then named pipes

inside the server's tcp/ip on the ip tab, IP1 is set to active, enabled, the ip address is 192.168.1.41 which is different from the laptop ip (192.168.1.39), there is no port number for IP1, should there be a port number? dynamic port is 0

IP2 is set to active, enable with address 127.0.0.1 and also does not have a port number, dynamic port is 0

IPAll is using dynamic port 1232 but also has no port number.

for the client TCP/IP setting the default port is 1433 and it is also enabled.

also downloaded and intalled SSMS-EE and under properties for the sql server >connection, the allow remote connection box is checked. I am using the default instance sqlexpress, there is another instance microsoftbcm (what is that?) and it also has the allow remote connection box checked.

server security is set to windows authentication

keep getting

clues appreciated, take care

What is the error message you are seeing?

|||

when i run aspnet_regsql and get to about the third page in the wizard and click on the dropdown for the database the error message i get is

Failed to query a list of database names from the SQL server

An error has occurred while establishing a conneciton to the server. when connecting to SQL server 2005, this failure may be casued the the fact that under the default settings SQL server does not allow remote connections. (provider: Named Pipes Provider, error: 40- Could not open a connection to SQL server)

no databases show up at all in the wizard.

not sure why or if i should be using the named pipes protocol,

a blog said to run this command- SQLCMD -s .\sqlexpress not sure what this does so i haven't tried it yet as the article seem to be for VS beta august.

thanks for responding Rob

|||this worked for me with the same problem:

from:ms-help://MS.VSCC.v80/MS.MSDN.v80/MS.SQL.v2005.en/udb9/html/914f7491-e2be-4b0d-b3aa-fe5409cdbafa.htm

---

By default, the default instance of Microsoft SQL Server Database Engine listens on named pipe \\.\pipe\sql\query. Named instances of SQL Server Database Engine and SQL Server Mobile listen on other pipes. Use SQL Server Configuration Manager to change the pipe used by the Database Engine.

There are three ways to connect to a specific named pipe with a client application:
Run the SQL Server Browser service on the server.|||

I'm having a similar problem (same error message) - and the above solution did not resolve it in my case. Does anyone else have any other ideas on this issue?

|||

OK, I think I have a solution to this one!

I did a little more research and came across this post on WebServerTalk.

This led me to the following post on MSDN's SQL Server Express blog:

http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

The way I set mine up was to follow the instructions in Step 2, option A in the MSDN post, then change my connection string to the following:

connectionStr = "server=[MachineName],[PortNo]; data source=[MachineName]\SQLEXPRESS; user id=[SQLServerUser]; password=[password]; Initial Catalog=[dbName]"

Example:

Machine Name = MyMachine

Port Number (as specified in the SQL Server Config) = 2301

User Id = dbReader

Password = p@.ssword

Database Name = MyDB

connectionStr = "server=MyMachine,2301; data source=MyMachine\SQLEXPRESS; user id=dbReader; password=p@.ssword; Initial Catalog=MyDB"

This worked for me - hope this helps others.

P.S. Does anyone have an idea how to make this work with the Integrated Security parameter (i.e., using "Integrated Security=SSPI;" instead of "userid=bla; password=yak")? Could not get this to work using that parameter - had to identify a specific SQL Server Login.

|||

not sure i can even connect locally, ran the sqlcmd -s -e \sqlexpress in a dos box and get the error message below, also ched the registry and the setting are:

name SQLexpress -- type reg_sz -- data mssql.1
not sure if i have ever connected locally, have never been able to get either the sqlcmd -e -s \sqlexpress to work, or the aspnet_regsql wixard to work, (is ther anothe way to test the local connection?) for the sqlcmd i get a get a message like this,

HResult 0x274D, Level 16, State 1
TCP Provider: No connection could be made because the target machine actively refused it

sqlcmd: Error Microsoft sql native client :an error has occurred while establishing a connection th the server. When conecting th SQL server 2005, this failure may be caused by the fact that unde rth edefault settings sql server does not allow remote connecitons. and the a login timeout expired.

the server has a different ip address than the laptop itself, sql express is installed on the laptop.

the aspnet_regsql error message is very similar,

|||

The SQL Express Blog (entry above, but here it is again for good measure, http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx) desicribes how to configure SQL Express and your computer to accept remote connections.

In addition to the steps you've taken, you have to open an Exception in the firewall for both SQL Server and SQL Browser; many people miss this step. The blog describes how to do this for the Windows Firewall, the process will be similar for other firewalls.

Hope this helps,

Mike Wachal
SQL Express

|||

Linking to a related thread:

permissions sql express and remote connection problems TIA

The issue in the above thread was that -s was used instead of -S for sqlcmd. The proper argument for the server name is -S with capital S.

Thanks
Laurentiu

|||Integrated security = SSPI works in my case because I set the login name into windows authentication instead of sql server authentication and give specific roles.|||

CSharpener,

I just had to post a big THANK YOU for taking the time to post what fixed it for you because it was also the solution for my problem. I'm running Windows Server Small Business Server and I was starting to think that maybe the Microsoft SQL Server Desktop Engines for Reporting and Sharepoint had something to do with my problem. So I've spent the past hour and a half crawling the web looking through all sorts of posts related to this subject and most of them had the same solution:
Enable Named Pipes in the SQL Server Configuration Manager. I did this about 4 different times just to make sure I was not missing anything. However it did not solve the issue.

My SQL instance is not default, it is named so once I removed the instance name from the pipe name I was able to get the ASPNET_REGSQL to find my database.

Going from:
\\.\pipe\MSSQL$MYSQLSERVERNAMEWASHERE\sql\query

To:
\\.\pipe\sql\query

Worked like a charm. Thanks for passing it along instead of just moving on to the next problem with the information hoarded in your head. :)

DR

|||An easy-to-miss behavior of the aspnet_regsql wizard (or command aspnet_regsql -W), is that the Server Textbox is pre-populated with your machine name. That will cause the wizard, in your case, to fail on the third page. You need to change the Server Textbox.Text from [MachineName] to [MachineName]\SQLEXPRESS.

That should help, no matter what protocols you have enabled.
|||

I am new to SQL 2005 and Visual Studio 2005. I used the following Connection string as given in a Visual Studio 2005 sample program.

ConnectionStr= "Server=(local);DataBase=;Integrated Security=SSPI"

If there are more than one SQL Server 2005 instance ( I only have SQL 2005 Express to test) even if I fixed the Remote Connections, firewall and Browser services I still get the error:

An error has occurred while establishing a conneciton to the server. when connecting to SQL server 2005, this failure may be casued the the fact that under the default settings SQL server does not allow remote connections. (provider: Named Pipes Provider, error: 40- Could not open a connection to SQL server)

Now I found the solution for this problem using integrated security parameter. I can connect to SQLExpress instance using the following string.

ConnectionStr = "Server=.\SQLExpress;DataBase=;Integrated Security=SSPI"

|||YES! YES! YES! Thanks for your post implemental.com. After reading through all of the above posts and getting pretty frustrated, I tried adding the SQLEXPRESS string to the server name as you suggest and everything suddenly worked! Thanks for your posting.|||

thanks! guys

Remote Connection Issue

Hello, I have a leb setup to install and test Microsoft Identity Integration Feature Pack. I have two servers running in two different forests and SQL running on one of the servers. I must connect to the SQL server from the othere machine but when I try connecting I get an error message that says "The service account cannot access SQL server. Ensure that the server is accessible, the service account is not a local account being used with a remote SQL server, and that the account doesn't already have a SQL login."

Any ideas what i could be doing wrong?

Hi,

Which Account is used to start the server is it domain account with proper privilege ?

refer the links http://support.microsoft.com/kb/555585 and http://msdn2.microsoft.com/en-us/library/ms143691.aspx for workaround.

Hemantgiri S. Goswami