ActiveX ActivePerl DTS Task

I need help with executing an ActiveX Perl DTS Task.

I have ActivePerl installed and I do not get a task error when I run it. The script works perfectly when I run it from a command prompt. The problem is that the task will not extract the files from the tar file.

sub Main()
{
#using modules
use Archive::Tar;
use Compress::Zlib;

#create a new tar archive object
my $tar = Archive::Tar->new;

#set the name of the compressed files
$main_tar = "C:\Inetpub\wwwroot\legacyrealestate\db\DW168E.tmp. tar";

#read the main tar file and extract files
$tar->read($main_tar,1);
$tar->extract();

return 0; # DTSTaskExecResult_Success;
}

Any clue?I think I know why it appears that it wasn't working. It worked but not like I expected. It extracted the files into the default sql server directory.

So My next question is how do specify the directory to extract to?

Originally posted by jcochran2003
I need help with executing an ActiveX Perl DTS Task.

I have ActivePerl installed and I do not get a task error when I run it. The script works perfectly when I run it from a command prompt. The problem is that the task will not extract the files from the tar file.

sub Main()
{
#using modules
use Archive::Tar;
use Compress::Zlib;

#create a new tar archive object
my $tar = Archive::Tar->new;

#set the name of the compressed files
$main_tar = "C:\Inetpub\wwwroot\legacyrealestate\db\DW168E.tmp. tar";

#read the main tar file and extract files
$tar->read($main_tar,1);
$tar->extract();

return 0; # DTSTaskExecResult_Success;
}

Any clue?|||This is really a perl question but I would try setting the directory by using the SetCwd(directory) command.|||Thanks I will try that.|||I keep getting a "Function not found" error. Can anybody give me a peice of sample code using Win32::SetCwd()?|||Here is the updated perl script.

#using modules
use Archive::Tar;
use Compress::Zlib;
use Win32::File;

sub Main()
{
#create a new tar archive object
my $tar = Archive::Tar->new;

#set the name of the compressed files
$main_tar = "C:\Inetpub\wwwroot\legacyrealestate\db\DW168E.tmp. tar";
$res_tar = "ListingsRESIDENTIAL-Residential.txt.gz";

# set the directory
$dir = "C:\Inetpub\wwwroot\legacyrealestate\db\";
Win32::SetCwd($dir);

#read the main tar file and extract files
$tar->read($main_tar,1);
$tar->extract();

return 0; # DTSTaskExecResult_Success;
}

Active/Active CLuster can not add 2nd Node

Help, I have an active/active cluster with SQL2k5 Ent with SP2 installed on node1 that is currently running live apps, I need to add the 2nd node to have fail over functionality but if I use the Change Install from Add or Remove Programs on the primary node to add the 2nd node I get the following error.

"The File 'c:\....\SqlRun_SQL.ms' is not a valid installation package for the product Microsoft SQL Server 2005(SQL2K5VVS01). Try to find the installation package 'SqlRun_SQL.msi' in a folder from which you can install Microsoft SQL Server 2005(SQL2K5VVS01).

No I assume this is because node 1 has had service pack two applied. Does anyone have instructions how I can add node two without having to completely uninstall Node 1, as the doc’s with SQL2005 SP2 say it can not be removed, a complete uninstall of 2005 must be done?

You may have to 'break' the cluster, install SQL and SP2 on your second node, and then reestablish the cluster.|||

Hmmm was hoping for a simpler sounding fix as not the confident with cluster administration, as this live cluster also has two other SQL2000 instances running in a side by side config, reporting services and file shares.

Also wondering is there a way to get the 'SqlRun_SQL.msi' from service pack two installer, as it may run if I could get it to read this?

Active/Active Cluster

I am trying to install an Active/Active cluster of SQL2000 on a Win2003 machine. I installed the default instance and a named instance. When both instances are on the same machine, they come up correctly. However, if I fail the named instance over to the
other node, it will not come up. If I then fail the default instance over to the other node the named instances starts. The error messages are as follows:
[sqsrvres] ODBC sqldriverconnect failed
[sqsrvres] checkODBCConnectError: sqlstate = 08001; native error = 11; message = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
[sqsrvres] ODBC sqldriverconnect failed
[sqsrvres] checkODBCConnectError: sqlstate = 01000; native error = 35; message = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
Is the default Instance and the named instance running in the same domain account context? Also, most people that use clustering would just use named instances...
|||Are the service account passwords the same on both machines? What are the
steps you took to install both virtual servers?
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com

Activating Trial Edition of SQL Server 2005

I have the following situation.
I installed a couple of months ago SQL Server 2005 Trial Edition which is En
teprise Edition I guess.
Currently I am testing replication on our company database.
Now. In a few months the Trial Version will expire.
Can I avoid setting up my Merge Replication again and re-installing everythi
ng from scratch?
Is there a way to activate NOT YET expired trial version ?
More to that I prefer to purchase the Standard Ed. which is less expensive t
han Enterprise.
Can I convert somehow the Trial Enteprise ed. into Standard WITHOUT having t
o re-install everything and possibly losing oall my settings.Issue a select @.@.version to determine what you are running. I think your
best bet is to script our your publications and subscribers, and then to
detacth the databases. Remove the trial version and install standard noting
that web synchronization and other features of merge replication present
only in EE will not be available.
Then run the publication and subscription scripts on the new server.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Yuri" <Yuri@.tester.de> wrote in message
news:5o-dnaz5Doik2dvYnZ2dnUVZ8qKdnZ2d@.giganews.com...
>I have the following situation.
> I installed a couple of months ago SQL Server 2005 Trial Edition which is
> Enteprise Edition I guess.
> Currently I am testing replication on our company database.
> Now. In a few months the Trial Version will expire.
>
> Can I avoid setting up my Merge Replication again and re-installing
> everything from scratch?
> Is there a way to activate NOT YET expired trial version ?
> More to that I prefer to purchase the Standard Ed. which is less expensive
> than Enterprise.
> Can I convert somehow the Trial Enteprise ed. into Standard WITHOUT having
> to re-install everything and possibly losing oall my settings.|||Hi Hillary,
thanks for your piece of advice.
This is actually a workaround solution.
Your are right, installing the Standard ed. over Trial Version isn't probabl
y the best idea.
But I guess you are mistaken saying that SE has no Web Merge Replication fea
utures
Look at this table: http://www.microsoft.com/sql/prodin...
es.mspx
Yuri

Activating Trial Edition of SQL Server 2005

I have the following situation.
I installed a couple of months ago SQL Server 2005 Trial Edition which is Enteprise Edition I guess.
Currently I am testing replication on our company database.
Now. In a few months the Trial Version will expire.
Can I avoid setting up my Merge Replication again and re-installing everything from scratch?
Is there a way to activate NOT YET expired trial version ?
More to that I prefer to purchase the Standard Ed. which is less expensive than Enterprise.
Can I convert somehow the Trial Enteprise ed. into Standard WITHOUT having to re-install everything and possibly losing oall my settings.Issue a select @.@.version to determine what you are running. I think your
best bet is to script our your publications and subscribers, and then to
detacth the databases. Remove the trial version and install standard noting
that web synchronization and other features of merge replication present
only in EE will not be available.
Then run the publication and subscription scripts on the new server.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Yuri" <Yuri@.tester.de> wrote in message
news:5o-dnaz5Doik2dvYnZ2dnUVZ8qKdnZ2d@.giganews.com...
>I have the following situation.
> I installed a couple of months ago SQL Server 2005 Trial Edition which is
> Enteprise Edition I guess.
> Currently I am testing replication on our company database.
> Now. In a few months the Trial Version will expire.
>
> Can I avoid setting up my Merge Replication again and re-installing
> everything from scratch?
> Is there a way to activate NOT YET expired trial version ?
> More to that I prefer to purchase the Standard Ed. which is less expensive
> than Enterprise.
> Can I convert somehow the Trial Enteprise ed. into Standard WITHOUT having
> to re-install everything and possibly losing oall my settings.

Acrobat Writer and Reporting Services

If I have Adobe Acrobat Professional installed in my Report Server, would I be able to toggle the document propeties of PDF files (Export to PDF) to make it not-printable, not-modifiable?

Is there any .dll that I can overwrite to change the default settings?

thanks

You could try writing your own rendering extension and output the report to PDF manually as well as setting the additional options you wish. Maybe you could hack it by making your extension call the report server via the webserice, retrieving the PDF output and setting the additional settings before returning the modified PDF from your extension.

For more information about writing custom rendering extensions go here http://msdn2.microsoft.com/es-es/library/ms153624.aspx

Acess Denied SQL Server doesnot Exist

Hi I recently installed a copy of SQL Server 2000 and was unable to connect
as my SQL server gives me the message "Acess Denied SQL Server doesnot
Exist". I did use all the trouble shooting help but couldnot rectify it. The
probelm seems to be with my logon. I am starting it with a single user mode.
It listens to TCP/IP, shared memory and named pipes. Even I have allowed the
1433 port on the firewall. But the error message it gives is Error: 15457,
Severity: 0, State: 1. Could someone please help?Where are you seeing the error and what is the message?
Error 15457 in SQL Server wouldn't have anything to do with
it and would actually indicate the someone is connecting.
What tool are you using to connect?
How are you starting in single user mode and is there any
reason why you need to do this?
What login are you using?
Can you ping the server?
Can you log onto the server and connect with one of the
tools - Query Analyzer, Enterprise Manager.
-Sue
On Tue, 28 Jun 2005 16:43:03 -0700, "Shiv"
<Shiv@.discussions.microsoft.com> wrote:

>Hi I recently installed a copy of SQL Server 2000 and was unable to connect
>as my SQL server gives me the message "Acess Denied SQL Server doesnot
>Exist". I did use all the trouble shooting help but couldnot rectify it. Th
e
>probelm seems to be with my logon. I am starting it with a single user mode
.
>It listens to TCP/IP, shared memory and named pipes. Even I have allowed th
e
>1433 port on the firewall. But the error message it gives is Error: 15457,
>Severity: 0, State: 1. Could someone please help?|||Hi! I am getting the error logon message with the comments "Acess Denied SQL
Server doesnot Exist". I am trying to connect through the service manager. I
have installed the evaluation version of SQL server on an XP professional
edition with both clients and server on the same machine. But it is not
connecting to the server. I have already pinged the server and it is
returning me the port numbers and ip addresses. I cannot connect to any of
the services. Does SQL server not runs on an XP professional edition?
"Sue Hoegemeier" wrote:

> Where are you seeing the error and what is the message?
> Error 15457 in SQL Server wouldn't have anything to do with
> it and would actually indicate the someone is connecting.
> What tool are you using to connect?
> How are you starting in single user mode and is there any
> reason why you need to do this?
> What login are you using?
> Can you ping the server?
> Can you log onto the server and connect with one of the
> tools - Query Analyzer, Enterprise Manager.
> -Sue
> On Tue, 28 Jun 2005 16:43:03 -0700, "Shiv"
> <Shiv@.discussions.microsoft.com> wrote:
>
>|||Hi,
Go to Control Panel -> Administrative Tools -> Services and make sure the
Sql Server service is running. This is one of the many possibilities that
might have happened.
"Shiv" wrote:
[vbcol=seagreen]
> Hi! I am getting the error logon message with the comments "Acess Denied S
QL
> Server doesnot Exist". I am trying to connect through the service manager.
I
> have installed the evaluation version of SQL server on an XP professional
> edition with both clients and server on the same machine. But it is not
> connecting to the server. I have already pinged the server and it is
> returning me the port numbers and ip addresses. I cannot connect to any of
> the services. Does SQL server not runs on an XP professional edition?
> "Sue Hoegemeier" wrote:
>

Acess Denied SQL Server doesnot Exist

Hi I recently installed a copy of SQL Server 2000 and was unable to connect
as my SQL server gives me the message "Acess Denied SQL Server doesnot
Exist". I did use all the trouble shooting help but couldnot rectify it. The
probelm seems to be with my logon. I am starting it with a single user mode.
It listens to TCP/IP, shared memory and named pipes. Even I have allowed the
1433 port on the firewall. But the error message it gives is Error: 15457,
Severity: 0, State: 1. Could someone please help?
Where are you seeing the error and what is the message?
Error 15457 in SQL Server wouldn't have anything to do with
it and would actually indicate the someone is connecting.
What tool are you using to connect?
How are you starting in single user mode and is there any
reason why you need to do this?
What login are you using?
Can you ping the server?
Can you log onto the server and connect with one of the
tools - Query Analyzer, Enterprise Manager.
-Sue
On Tue, 28 Jun 2005 16:43:03 -0700, "Shiv"
<Shiv@.discussions.microsoft.com> wrote:

>Hi I recently installed a copy of SQL Server 2000 and was unable to connect
>as my SQL server gives me the message "Acess Denied SQL Server doesnot
>Exist". I did use all the trouble shooting help but couldnot rectify it. The
>probelm seems to be with my logon. I am starting it with a single user mode.
>It listens to TCP/IP, shared memory and named pipes. Even I have allowed the
>1433 port on the firewall. But the error message it gives is Error: 15457,
>Severity: 0, State: 1. Could someone please help?
|||Hi! I am getting the error logon message with the comments "Acess Denied SQL
Server doesnot Exist". I am trying to connect through the service manager. I
have installed the evaluation version of SQL server on an XP professional
edition with both clients and server on the same machine. But it is not
connecting to the server. I have already pinged the server and it is
returning me the port numbers and ip addresses. I cannot connect to any of
the services. Does SQL server not runs on an XP professional edition?
"Sue Hoegemeier" wrote:

> Where are you seeing the error and what is the message?
> Error 15457 in SQL Server wouldn't have anything to do with
> it and would actually indicate the someone is connecting.
> What tool are you using to connect?
> How are you starting in single user mode and is there any
> reason why you need to do this?
> What login are you using?
> Can you ping the server?
> Can you log onto the server and connect with one of the
> tools - Query Analyzer, Enterprise Manager.
> -Sue
> On Tue, 28 Jun 2005 16:43:03 -0700, "Shiv"
> <Shiv@.discussions.microsoft.com> wrote:
>
>
|||Hi,
Go to Control Panel -> Administrative Tools -> Services and make sure the
Sql Server service is running. This is one of the many possibilities that
might have happened.
"Shiv" wrote:
[vbcol=seagreen]
> Hi! I am getting the error logon message with the comments "Acess Denied SQL
> Server doesnot Exist". I am trying to connect through the service manager. I
> have installed the evaluation version of SQL server on an XP professional
> edition with both clients and server on the same machine. But it is not
> connecting to the server. I have already pinged the server and it is
> returning me the port numbers and ip addresses. I cannot connect to any of
> the services. Does SQL server not runs on an XP professional edition?
> "Sue Hoegemeier" wrote:

Account problem when creating a new publication

I've got SQL Server Developer installed on my laptop. I'm trying to get
merge replication to work, but when I try to create a new publisher, when I
select the option to make SQL Server on my laptop its own distributor, I
then get an error msg. saying I've chosen a local system account, and
replication will not work. It then sends me to a publications properties
form to select a new account. I have no other accounts, this is just run
from my laptop. Can some kind soul help me and tell me what I need to do
to get this working?
My end result is to be able to get merge replication set up so I can sync.
with a handheld device using SQL Server 2000 CE.
Thanks in advance for any assistance.
The account that SQL Server and the Agent need to run in something other
than a Local account.
"DaveM" <nosebop@.yahoo.com> wrote in message
news:OFNJHikLFHA.2824@.TK2MSFTNGP10.phx.gbl...
> I've got SQL Server Developer installed on my laptop. I'm trying to get
> merge replication to work, but when I try to create a new publisher, when
I
> select the option to make SQL Server on my laptop its own distributor, I
> then get an error msg. saying I've chosen a local system account, and
> replication will not work. It then sends me to a publications properties
> form to select a new account. I have no other accounts, this is just
run
> from my laptop. Can some kind soul help me and tell me what I need to do
> to get this working?
> My end result is to be able to get merge replication set up so I can sync.
> with a handheld device using SQL Server 2000 CE.
> Thanks in advance for any assistance.
>
>

Accessing two databases simultaneously

I have Crystal Reports 8.5 installed at my site. Was looking at accessing data from 2 databases(Oracle & SQL Server 2000) simultaneously, i.e creating a report which would simultaneously access these 2 data sources. Can you tell me the possibility of doing this.
Thanks.You can make your report connect to SQL Server only..and retrieve Oracle data from SQL Server as a linked server..
this article can give you an idea about this:
How to Link Different Data Sources Together (http://www.dev-archive.com/Csharp/Csharp/cs_data/searching/article.php/c9953/)|||Hi,

I think we need to use Business Views this future is available in Crystal Reports10.
I don't think by using Crystal Reports 8.5 we can achive this...

Accessing SQL Server on another machine

Hello all.

I am currently running a web server with Windows 2000 Server installed. It is a Pentium II 400 MHz, and also acts as the router on our network. I am worried that installing MSDE on this same server might drain the server resources, so I installed MSDE on one of the computers in our internal network. How do I set up my connection string to access the database on another machine in the same network?

Currently I use: Server="AnotherComputer";TrustedConnection="True";Database="MyDatabase"

When I use that, it tells me that the server can't be found. All computers behind the router have static IP addresses, but even when I type the IP address it still can't find the server. Any suggestions?First thing: It would be better to use the SQL Servers IP address than the name.

Second: Trusted Connectivty will be a problem unless you do some sort of impersonation. ASP.NET runs under the guise of a process which requires an account for credentialing. Normally this is the ASPNET user in Windows 2000 and NETWORK SERVICE in 2003. For trusted connection to work this user must have db access.

Third: Can you even see/ping the SQL Server from the web server? Is TCP/IP enabled or just named pipes?

Accessing SQL Server installed on dynamic IP based PC

Hi,
I'm trying to make a application that get data from sql server that is
installed on a pc that is connected to internet through dial-up. As we
know that in dialup based connection pc gets dynamic ip. I want to
fetch sql server data from this PC.
how can we setup ?
Indra BisenYou can use a dynamic DNS web service, like http://www.no-ip.com/ .
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF
"Indra Bisen" <indra.bisen@.gmail.com> wrote in message
news:1155477113.077345.26960@.i3g2000cwc.googlegroups.com...
> Hi,
> I'm trying to make a application that get data from sql server that is
> installed on a pc that is connected to internet through dial-up. As we
> know that in dialup based connection pc gets dynamic ip. I want to
> fetch sql server data from this PC.
> how can we setup ?
> Indra Bisen
>

Accessing SQL Server installed on dynamic IP based PC

Hi,
I'm trying to make a application that get data from sql server that is
installed on a pc that is connected to internet through dial-up. As we
know that in dialup based connection pc gets dynamic ip. I want to
fetch sql server data from this PC.
how can we setup ?
Indra BisenYou can use a dynamic DNS web service, like http://www.no-ip.com/ .
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF
"Indra Bisen" <indra.bisen@.gmail.com> wrote in message
news:1155477113.077345.26960@.i3g2000cwc.googlegroups.com...
> Hi,
> I'm trying to make a application that get data from sql server that is
> installed on a pc that is connected to internet through dial-up. As we
> know that in dialup based connection pc gets dynamic ip. I want to
> fetch sql server data from this PC.
> how can we setup ?
> Indra Bisen
>

Accessing SQL Server Databases from Networked PC

Hello all. I have just built another PC (New PC)and have it connected to my
Original PC via a LAN. I have my SQL Server 2000 installed on the Original
PC. Both PCs use WinXP Pro OS. I believe I now have to install the Client
Tools on the New PC but after that, how do I access the SQL Server that is
on the Original PC. The SQL Server is setup with mixed (both Windows
Authentication and SQL Server Authentication). Just how do I use the SQL
Query Analyzer that I just installed on the New PC to connect to and
retreive data from the SQL Databases which are on the Original PC? Thanks
in advance for any help, Jim.Hello all. Dissregard this request for assistance as I was able to figure it
out. I can now connect the New PC to the SQL Server in the Original PC,
write my query and the results are displayed on the New PC over the Network.
Have a good day. Jim.

"Jim Richards" <JWRichards@.satx.rr.com> wrote in message
news:RGoOd.38259$uA.22293@.fe1.texas.rr.com...
> Hello all. I have just built another PC (New PC)and have it connected to
> my Original PC via a LAN. I have my SQL Server 2000 installed on the
> Original PC. Both PCs use WinXP Pro OS. I believe I now have to install
> the Client Tools on the New PC but after that, how do I access the SQL
> Server that is on the Original PC. The SQL Server is setup with mixed
> (both Windows Authentication and SQL Server Authentication). Just how do I
> use the SQL Query Analyzer that I just installed on the New PC to connect
> to and retreive data from the SQL Databases which are on the Original PC?
> Thanks in advance for any help, Jim.

Accessing SQL Server 2005 through Vista

I just bought a new HP laptop that has Vista installed. Not happy about the OS but it is what it is...

I need to use Enterprise Manager, or an equivalent, to access a remote server, running SQL 2005.

With XP, I always installed and used SQL Server 2000 Client features.

Vista does not play well with SQL 2000 so I am looking for an alternative to simply be able to access, and perform DTS functions, a remote SQL 2005 system.

Does SQL Server 2005 Express offer client alias features?

Can anyone recommend another approach or product?

Thank you,

SteveVista sucks, no doubt about it. I had to install it at work, but it will be a LONG time before I choose to install it at home.
That said, what errors or issues to you run into running Enterprise Manager on Vista? This is one thing that I have not had a problem with.|||Thanks blindman,

Are you referring to EM in SQL 2000 or 2005? I've tried both with different issues.

Steve|||EM is 2000. SSMS is 2005. I am running both on a Vista desktop.|||blindman,

I have installed SMSS and it is running. However, when I try to open or modify any tables or views, SQL stalls out.

I can see the databases, the table names but when I try to open any table, regardless of size, it shoes (expanding) but then stalls out.

I have created an exception in Windows firewall...

Thanks for any insight,

Steve|||Is the SQL Server local or remote?|||remote.

I have comfirmed that it is set up to allow remote connections.

thanks|||If SSMS opens correctly under Vista, but merely stalls out when trying to connect to a remote database server, then my guess is that you have a network issue.

Accessing SQL Server 2005 through Vista

I just bought a new HP laptop that has Vista installed.

I need to use Enterprise Manager, or an equivalent, to access a remote server, running SQL 2005.

With XP, I always installed and used SQL Server 2000 Client features.

Vista does not play well with SQL 2000 so I am looking for an alternative to simply be able to access, and perform DTS functions, a remote SQL 2005 system.

Does SQL Server 2005 Express offer client alias features?

Can anyone recommend another approach or product?

Thank you,

Steve

Just install the SQL 2005 client tools with the DTS add tool (available from microsoft.com/sql).|||SQL 2000 is not supported on Vista and you have depend only on SQL 2005 - http://www.microsoft.com/sql/prodinfo/previousversions/faq-sql_on_vista.mspx fyi on vista support.|||

SQL Server Configuration Manager lets you define aliases for servers in the SQL Native Client Configuration | Aliases node. You can register servers in Management Studio to simplify connecting to them as well.

Hope this helps,

Steve

Accessing SQL Server 2005 through Vista

I just bought a new HP laptop that has Vista installed.

I need to use Enterprise Manager, or an equivalent, to access a remote server, running SQL 2005.

With XP, I always installed and used SQL Server 2000 Client features.

Vista does not play well with SQL 2000 so I am looking for an alternative to simply be able to access, and perform DTS functions, a remote SQL 2005 system.

Does SQL Server 2005 Express offer client alias features?

Can anyone recommend another approach or product?

Thank you,

Steve

Just install the SQL 2005 client tools with the DTS add tool (available from microsoft.com/sql).|||SQL 2000 is not supported on Vista and you have depend only on SQL 2005 - http://www.microsoft.com/sql/prodinfo/previousversions/faq-sql_on_vista.mspx fyi on vista support.|||

SQL Server Configuration Manager lets you define aliases for servers in the SQL Native Client Configuration | Aliases node. You can register servers in Management Studio to simplify connecting to them as well.

Hope this helps,

Steve

Accessing SQL Server 2005 Express

I recently downloaded SQL Server 2005 Express Edition. Everything was installed correctly without any problems. However, when I went to my Program list, the only thing listed for Microsoft SQL Server 2005, was Configuration tool.

Where is the actual program where I can write and run queries? How do I access the server?I think that the 'default' installation only installs SQL Server. If you want the client tools, you will need to insert the media again and select Client Tools (or something like that...)|||The Express SKU does not include the client tools you are referring to. If you want to install these, you need to download Express Advanced and add Management Studio Express. This will give you the UI-based client tools you are looking for.

Thanks,
Sam Lester (MSFT)

Accessing SQL Server

Hi All
I have installed SQL Server at client place, and client is having 30 compute
rs with 1 server network and Windows 2000 Based.
every thing was working fine and every client was able to access SQL Server,
but now i donno wut happend, it's not connecting with server and this error
message appears when i connect through ODBC or Enterprise Manager
Connection Failed:
SQLState: '01000'
SQL Server Error: 3
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
Connection Failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exists or access denied.
this error does not appears if i log in as Domain Administrator, for resolvi
ng this error, i checked the authentication mode and it is Windows and SQL S
erver, wut could it be.
its very urgent
Email Response will be appreciated
Anwar
anwer_80@.yahoo.comTry making a new ODBC DSN and connect to the server. If it fails post the
entire Error message here.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

accessing sql express peer to peer on xp home

HI

2 pc's networked on XP home - SQL Express installed on one (on both actually, but that's probably superfluous info)

I've got the CTP studio express installed on both, but can't connect to the instance on the other machine - I've enabled TCPIP and named pipes, restarted the services, the XP filewall is disabled and still no luck - I've got mixed mode authentication...

What else can I try - how do I fix ?

THanks

Bruce

I haven't tried this but instructions at

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

GS

|||

You can also use the Surface Area Configuration tool to enable remote connections.

Thanks

Laurentiu