Need to collect serverinfo

Is there a way that I can run some batch file or query to go out to all SQL
Servers and collect some ServerInfo such as Windows Version/Service Pack,
SQL Version/Service Pack,CPU ( Number and Type) ,Server Model(HP,Dell),
Memory , Disk Space, NIC settingg(IP address)etc and stick it into a table
for reporting. The more info the better..
Hello,
The below extended proc will give info regarding OS, SQL Server, Memory and
CPU.
Master..xp_msver
Thanks
Hari
"Hassan" <Hassan@.hotmail.com> wrote in message
news:%23cHiWIOQHHA.3872@.TK2MSFTNGP06.phx.gbl...
> Is there a way that I can run some batch file or query to go out to all
> SQL Servers and collect some ServerInfo such as Windows Version/Service
> Pack, SQL Version/Service Pack,CPU ( Number and Type) ,Server
> Model(HP,Dell), Memory , Disk Space, NIC settingg(IP address)etc and stick
> it into a table for reporting. The more info the better..
>
sql

Need to collect serverinfo

Is there a way that I can run some batch file or query to go out to all SQL
Servers and collect some ServerInfo such as Windows Version/Service Pack,
SQL Version/Service Pack,CPU ( Number and Type) ,Server Model(HP,Dell),
Memory , Disk Space, NIC settingg(IP address)etc and stick it into a table
for reporting. The more info the better..Hello,
The below extended proc will give info regarding OS, SQL Server, Memory and
CPU.
Master..xp_msver
Thanks
Hari
"Hassan" <Hassan@.hotmail.com> wrote in message
news:%23cHiWIOQHHA.3872@.TK2MSFTNGP06.phx.gbl...
> Is there a way that I can run some batch file or query to go out to all
> SQL Servers and collect some ServerInfo such as Windows Version/Service
> Pack, SQL Version/Service Pack,CPU ( Number and Type) ,Server
> Model(HP,Dell), Memory , Disk Space, NIC settingg(IP address)etc and stick
> it into a table for reporting. The more info the better..
>

Need to collect serverinfo

Is there a way that I can run some batch file or query to go out to all SQL
Servers and collect some ServerInfo such as Windows Version/Service Pack,
SQL Version/Service Pack,CPU ( Number and Type) ,Server Model(HP,Dell),
Memory , Disk Space, NIC settingg(IP address)etc and stick it into a table
for reporting. The more info the better..Hello,
The below extended proc will give info regarding OS, SQL Server, Memory and
CPU.
Master..xp_msver
Thanks
Hari
"Hassan" <Hassan@.hotmail.com> wrote in message
news:%23cHiWIOQHHA.3872@.TK2MSFTNGP06.phx.gbl...
> Is there a way that I can run some batch file or query to go out to all
> SQL Servers and collect some ServerInfo such as Windows Version/Service
> Pack, SQL Version/Service Pack,CPU ( Number and Type) ,Server
> Model(HP,Dell), Memory , Disk Space, NIC settingg(IP address)etc and stick
> it into a table for reporting. The more info the better..
>

Need to Change Developers Acct to Windows Authentication

I have my SQL 7.0 server set for Mixed security. I see now (finally)
the advantages of having windows authentication security for windows
groups.
I do most of my developing in Access Projects which require a login of
some type. I have been using my SQL login to develop with SQL and
then when I give it to the user, I set the project to use Windows
authentication. I want to be able to have Windows authentication on
my domain account but the user name for my windows account is the same
as my SQL account and it won't let me change the existing account.
Now what happens is after I develop the product I have to have the
user login and go in and change to windows authentication. It won't
let me do it with my sql account.

I fear that if I delete my sql account and create a windows
authentication account all the views, sps, etc. that I have created
will still have the reference to the sql login and therefore not work.

Do I need to have a generic sql account for developing? One thought I
had was to create a new domain account so I can create that windows
login and at least get my most recent projects working like I want to?

Hope this makes sense to someone.
Thanks in advance for your time.
Sherry"sherkozmo" <skosmicki@.sfmc-gi.org> wrote in message
news:3ff08a65.0409280648.2d0c3d4f@.posting.google.c om...
>I have my SQL 7.0 server set for Mixed security. I see now (finally)
> the advantages of having windows authentication security for windows
> groups.
> I do most of my developing in Access Projects which require a login of
> some type. I have been using my SQL login to develop with SQL and
> then when I give it to the user, I set the project to use Windows
> authentication. I want to be able to have Windows authentication on
> my domain account but the user name for my windows account is the same
> as my SQL account and it won't let me change the existing account.
> Now what happens is after I develop the product I have to have the
> user login and go in and change to windows authentication. It won't
> let me do it with my sql account.

You might find this post from yesterday useful - it gives a short overview
of moving from SQL to Windows authentication:

http://groups.google.com/groups?hl=...s.prodi gy.com

One solution to your issue (if I understood correctly) is to connect as sa,
drop the SQL login, grant login to your Windows account, then logout and
connect with Windows authentication.

> I fear that if I delete my sql account and create a windows
> authentication account all the views, sps, etc. that I have created
> will still have the reference to the sql login and therefore not work.

If the objects are owned by dbo, then there should be no problem. If the
objects are owned by a SQL login, then you can always change the owner with
sp_changeobjectowner - the bext practice would be to use dbo for production
objects anyway.

> Do I need to have a generic sql account for developing? One thought I
> had was to create a new domain account so I can create that windows
> login and at least get my most recent projects working like I want to?

It is almost always best to avoid generic accounts - there's no way to know
who is really using it, so auditing and permissions are difficult to
implement properly. The best solution is probably roles eg. your Windows
account is in the db_owner role, but user accounts are in a role with more
limited permissions.

> Hope this makes sense to someone.
> Thanks in advance for your time.
> Sherry

You're welcome.

Simon

Need to change connection string for SQL 2005?

Hi,
DevStudio 2003, SQL Server 2005, Windows 2000 Pro SP4
I have been using the Enterprise Library Data Access Application Block to
connect to a local SQL 2000 database. The connection string parameters are:
<connectionStrings>
<connectionString name="Temp Connection String">
<parameters>
<parameter name="database" value="Temp" isSensitive="false" />
<parameter name="Integrated Security" value="True" isSensitive="false"
/>
<parameter name="packet size" value="4096" isSensitive="false" />
<parameter name="persist security info" value="false"
isSensitive="false" />
<parameter name="server" value="(local)" isSensitive="false" />
</parameters>
</connectionString>
</connectionStrings>
Having then removed SQL2000 and replaced it with SQL2005, the above
connection parameters no longer work. In order to connect, I'm having to
replace "(local)" with the explicit IP address of the local PC.
Can SQL 2005 be made to work with "(local)"? Having to change the "server"
value to the IP address means changing my installer to fill in this value,
which I'd rather not do. It also means that other developers in the team
have to change the connection string parameters in order to test on their
local databases.
For your information, SQL 2005 is configured to use both the Shared Memory &
Named Pipes protocols. Native Client configuration WAS setup with Shared
Memory first and Named Pipes second. I've tried disabling Shared Memory and
forcing Named Pipes to be used (on the basis that the SQL 2000 installation
was using Named Pipes) but to no avail.
Regards
David RazzettiHmmh, (local) should work on SQL2k5, whats the error message the
application Block is throwing ?
HTH, jens Suessmeyer.|||Hi Jens,
I'm using the application block to serve my code with SqlConnection objects.
The application block successfully supplies a SqlConnection object, but a
call to 'Open()' on the connection throws the SqlException "SQL Server does
not exist or access denied".
Regards
David Razzetti
"Jens" wrote:

> Hmmh, (local) should work on SQL2k5, whats the error message the
> application Block is throwing ?
> HTH, jens Suessmeyer.
>|||Hmmh, strange one. Didi you try just a "." for connecting to SQL Server
?
HTH, Jens Suessmeyer.|||Hi Jens,
"." appears to work correctly with both SQL 2000 and SQL 2005, so I guess I
can use that instead of "(local)". I'd still be interested to hear from
anyone who knows why "(local)" might not be working on my installation of SQ
L
2005.
Regards
David Razzetti
"Jens" wrote:

> Hmmh, strange one. Didi you try just a "." for connecting to SQL Server
> ?
> HTH, Jens Suessmeyer.
>|||Don=B4t know what version / build you are using but in earlier build the
local was replaced by localhost.
HTH, jens Suessmeyer.

Need to change connection string for SQL 2005?

Hi,
DevStudio 2003, SQL Server 2005, Windows 2000 Pro SP4
I have been using the Enterprise Library Data Access Application Block to
connect to a local SQL 2000 database. The connection string parameters are:
<connectionStrings>
<connectionString name="Temp Connection String">
<parameters>
<parameter name="database" value="Temp" isSensitive="false" />
<parameter name="Integrated Security" value="True" isSensitive="false"
/>
<parameter name="packet size" value="4096" isSensitive="false" />
<parameter name="persist security info" value="false"
isSensitive="false" />
<parameter name="server" value="(local)" isSensitive="false" />
</parameters>
</connectionString>
</connectionStrings>
Having then removed SQL2000 and replaced it with SQL2005, the above
connection parameters no longer work. In order to connect, I'm having to
replace "(local)" with the explicit IP address of the local PC.
Can SQL 2005 be made to work with "(local)"? Having to change the "server"
value to the IP address means changing my installer to fill in this value,
which I'd rather not do. It also means that other developers in the team
have to change the connection string parameters in order to test on their
local databases.
For your information, SQL 2005 is configured to use both the Shared Memory &
Named Pipes protocols. Native Client configuration WAS setup with Shared
Memory first and Named Pipes second. I've tried disabling Shared Memory and
forcing Named Pipes to be used (on the basis that the SQL 2000 installation
was using Named Pipes) but to no avail.
Regards
David Razzetti
Hmmh, (local) should work on SQL2k5, whats the error message the
application Block is throwing ?
HTH, jens Suessmeyer.
|||Hi Jens,
I'm using the application block to serve my code with SqlConnection objects.
The application block successfully supplies a SqlConnection object, but a
call to 'Open()' on the connection throws the SqlException "SQL Server does
not exist or access denied".
Regards
David Razzetti
"Jens" wrote:

> Hmmh, (local) should work on SQL2k5, whats the error message the
> application Block is throwing ?
> HTH, jens Suessmeyer.
>
|||Hmmh, strange one. Didi you try just a "." for connecting to SQL Server
?
HTH, Jens Suessmeyer.
|||Hi Jens,
"." appears to work correctly with both SQL 2000 and SQL 2005, so I guess I
can use that instead of "(local)". I'd still be interested to hear from
anyone who knows why "(local)" might not be working on my installation of SQL
2005.
Regards
David Razzetti
"Jens" wrote:

> Hmmh, strange one. Didi you try just a "." for connecting to SQL Server
> ?
> HTH, Jens Suessmeyer.
>
|||Don=B4t know what version / build you are using but in earlier build the
local was replaced by localhost.
HTH, jens Suessmeyer.
sql

Need to change Authentication type of my first DB in SQL05

* I was able to configure and install the DB

* I accidentally selected Windows Authentication

Now it won't let me login and keeps giving me an error.

Question: how do i change the authentication type without getting into the db? is there something I'm missing?

The authentication method is Server level, not database level. (Are you able to access the Server -but not a specific database?)

IF so, using SSMS, in the Object Explorer pane, right-click on the Server, and then select the [Security] tab. Change the authentication method there.

If you are not able to access the Server using SSMS, it may be just as quick for you to re-install (or) let us know so we can walk you through the process.

|||Sql service is necessary after changing the authentication mode on server level. Hence do a restart after changing the authentication mode.

Need to add additional NIC to SQL cluster - to enable teaming.

Hi
I have 2 questions, but related!
We currently have a Windows 2000 Adv server running SQL Ent 2000 as a 2 node
cluster.
Each node currently has 2 NICs installed, one NIC for the local heartbeat
and the other for the LAN connection.
We now need to add another NIC to each cluster node for failover resillience
on the LAN connection.
The idea is to add the extra NIC, so that we can implement teaming on 2
NICs.
1.What needs to be done to the cluster in order to achieve this and ensure
that the cluster still functions as per normal.
2. The installed NIC has 2 ports, so i assume that additional NIC purchased
may be different, my guess is that teaming different type NIC cards is not a
good idea, therefore i would like to reconfigure for the teaming to be on
the NIC with the 2 ports and the heartbeat on the newly purchased NIC. - Is
this a big job- what needs to be carried out in order to achive this!!!
Cheers Ray
Answers below...
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
<Ray> wrote in message news:eWEmvKBGFHA.2932@.TK2MSFTNGP10.phx.gbl...
> Hi
> I have 2 questions, but related!
> We currently have a Windows 2000 Adv server running SQL Ent 2000 as a 2
> node
> cluster.
> Each node currently has 2 NICs installed, one NIC for the local heartbeat
> and the other for the LAN connection.
> We now need to add another NIC to each cluster node for failover
> resillience
> on the LAN connection.
> The idea is to add the extra NIC, so that we can implement teaming on 2
> NICs.
> 1.What needs to be done to the cluster in order to achieve this and ensure
> that the cluster still functions as per normal.
A properly configured TEAM is not seen by the cluster. In other words, its
seamless. It just works like a single NIC and the Cluster is never the wiser
Cool huh?

> 2. The installed NIC has 2 ports, so i assume that additional NIC
> purchased
> may be different, my guess is that teaming different type NIC cards is not
> a
> good idea, therefore i would like to reconfigure for the teaming to be on
> the NIC with the 2 ports and the heartbeat on the newly purchased NIC. -
> Is
> this a big job- what needs to be carried out in order to achive this!!!
>
Take everything offline - cluster services and all resources. Change the
IP's on the NIC - on each node. Do a few ping tests to verify things are
working. Start the cluster service and use "." to start the Cluster
Administrator.
Use these for information:
http://support.microsoft.com/default...b;en-us;244980
http://support.microsoft.com/default...b;en-us;230356
Good luck, its really not that bad.

> Cheers Ray

Need SQL server advice

Hi, I need some advice concerning a vb.net windows application I'm building using SQL server as it's database.

The idea is to have a main enterprise SQL server database on the company network. The application will be installed on stand alone computers with it's own Standard SQL server database which will mirror the network database. This is so users can work with the application when not connected to the network.

The Network database will often be updated with new data and I will program the application so that everytime it is opened it will check the network database for new data and then update the local database. Of course this can only happen if the computer is connected to the network.

My questions are:

1. When installing the application on a users computer is it possible to initate the setup for the local SQL server in the application setup?

2.Once the setup is complete can there be a transfer of all the data tables and stored procedures on the network database to the local database automatically or would I have to create all that through code?

3.When there is an update of data from the network database to the local database can this be done transparently to the user or would this have to happen through DTS.

thanks for any advice on these questions

1. When installing the application on a users computer is it possible to initate the setup for the local SQL server in the application setup?

You must have a "class module" in the application that stores the connection string. when the application run the very first time you may read the connection string from a file then store it to the CM.connstring

At the form load event of every form you can assign the connection string to your connection object.

sqlconn.connectionstring=cm.connstring.

2.Once the setup is complete can there be a transfer of all the data tables and stored procedures on the network database to the local database automatically or would I have to create all that through code?

you must design a transactional replication or merge replication with the server

3.When there is an update of data from the network database to the local database can this be done transparently to the user or would this have to happen through DTS.

answer on #2 resolves this also

sql

Need SQL consultant/troubleshooter

A site is having seemingly random lockups and slowdowns on roughly 8
PC's running a Windows app client talking to a SQL Server 2000 server.
I am trying to find a qualified SQL consultant in the Eastern North
Carolina or Tidewater, VA area to take alook and provide guidance as
to where the problem lies.
Where should I look for such a consultant?
Thanks
www.icca.org
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
"Doug Lucy" <dlucy@.mindspring.com> wrote in message
news:vhc6b0l5fm01q8elph279t4c772algogtq@.4ax.com...
> A site is having seemingly random lockups and slowdowns on roughly 8
> PC's running a Windows app client talking to a SQL Server 2000 server.
> I am trying to find a qualified SQL consultant in the Eastern North
> Carolina or Tidewater, VA area to take alook and provide guidance as
> to where the problem lies.
> Where should I look for such a consultant?
> Thanks

Need Novell Network Connection without logging on first

I am new to SSIS but this does not seem like it should be a hard thing to do. Here is the background:

Windows Server 2003

SQL Server 2005

SSIS

Logged in to server as Admin

I've created a SSIS package that I want to run as a Job. In it there is a Ole DB Connection to a VFP Database on a Novell Server. Client for Netware Services is started when server is but NOT logged into. When I created the package everything runs fine. Note that I had to login when I created the Data Link. I can even run it from the SQL Server Package Store. As soon as I restart the server and try to run it I get an error that the file path is invalid in both SSIS and the Package Store. I check the connection string and it looks good.

The connection is availible in My Network Places

If I open the connection and login it runs fine again.

How do I intiate the network connection and then close it again?

Cory Bonallo

Retail Services

Developer

Aren't there some NET USE commands (or NetWare equivalents) that you could use to create the connection without having to log in?
|||

I've never used anything like that. Should there be a setting or something in the SSIS connection manager? Do you have any examples? Thanks for your help!

Cory Bonallo

Retail Services

Developer

|||

Cory Bonallo wrote:

I've never used anything like that. Should there be a setting or something in the SSIS connection manager? Do you have any examples? Thanks for your help!

No, this is more in the Windows arena than SSIS. Taking the Novell client out of the picture for the moment, when you're not logged into the machine, none of your drive mappings are active since those are user-specific. Your package may work fine when you're logged it, but when it tries to run unattended with nobody logged in, it can no longer access mapped drives and fails.

This comes up from time to time here on the forum, but the search is failing me at the moment for good threads. This one applies, but isn't a stellar example.

With the Windows client, the NET USE command (try "net use /?" from the Windows command prompt) can be used to make these connections. If you're running the SSIS package from SQL Agent, you can use CmdExec steps before your package to create a connection with NET USE and one after the package to delete it.

I have no idea how having the NetWare client in the picture might change things. I don't know if NET USE will work or if there is a different command you have to use to accomplish this.

|||

Well I thought that did it. But now I can't get it to run in a job step. I cant seem to figure out the syntax or something for cmdExec.

Here is what I did:

in dos window typed "net use \\jds1\vol3 /user:admin" works great!

Created a job step as Operating System (cmd Exec) and typed in:

"net use" \\jds1\vol3 /user:admin

Got this error:

04/16/2007 11:05:45,fred,Error,1,TESTSERVER,fred,Open Novell Connection,,Executed as user: JENSENNT1\CORYB. The process could not be created for step 1 of job 0x7FE4E946E4D7E944A13A2AB6551A270B (reason: The system cannot find the file specified).The step failed.,00:00:00,0,0,,,,0

So I tried several other changes and still same error...

What am I missing?

Cory

|||Try:

"C:\WINDOWS\system32\net.exe" use \\server\share /user:admin

"net use" is not a command. "use" is an argument to net.exe.|||

Thank you Phil. The more I use this tool the dumber I feel! So now I don't get an error but it just sits on that step. I'm assuming it has something to do with a return success code. Try as I might I just can't find any examples or instructions on how to code for this. Is there a way to reture a success code. I left it a zero because the articles I found said that was the default success code. Agail thanks for your help!

Cory

|||

Cory Bonallo wrote:

Thank you Phil. The more I use this tool the dumber I feel! So now I don't get an error but it just sits on that step. I'm assuming it has something to do with a return success code. Try as I might I just can't find any examples or instructions on how to code for this. Is there a way to reture a success code. I left it a zero because the articles I found said that was the default success code. Agail thanks for your help!

Cory

I don't think its related to the return code. I think it probably isn't returning. I see you're specifying a user name but no password. The Net.exe may be prompting and waiting for a response. Try passing the password too.

"C:\WINDOWS\system32\net.exe" use \\server\share /user:admin mypassword

|||

You were right. It was the password. Now can you tell me why the connection is not persisting to the next job step? So here is what I want to do:

Step 1: open network connection

Step 2: run dtsx package that uses that connection

Step 3: Close network connection

Seems simple enough?

Cory

|||Look at either mapping a drive to that share, or using the /PERSISTENT:YES flag.|||

Phil Brammer wrote:

Look at either mapping a drive to that share, or using the /PERSISTENT:YES flag.

Or combining all three into a single step? Perhaps by putting them in a batch file?
|||

JayH wrote:

Or combining all three into a single step? Perhaps by putting them in a batch file?

Yep.|||

Thabk you both very much. What I ended up doing is adding an Excute Process Task to Open the connection, run the rest of the steps of the package and then close the connection. Thanks again to all!!!

Cory

|||

I did get the net use working in the Job as a part of an SSIS package. Now I am trying to use the same process to open a connection to Novell in the Query editor and setting up a stored procedure that a Web service can call to get a connection to an access.mdb linked server on the Novell drive. When I try to execute via xp_cmdshell the command succeeds but does not make the conncetion availible to any other session. Then when I ran it in a batch to do a simple file copy the net use command succeeded but the copy failed. When I used impersonate it did not change the user from NT AUTHORITY/? I can't a channel opened.

Cory

|||

I did get the net use working in the Job as a part of an SSIS package. Now I am trying to use the same process to open a connection to Novell in the Query editor and setting up a stored procedure that a Web service can call to get a connection to an access.mdb linked server on the Novell drive. When I try to execute via xp_cmdshell the command succeeds but does not make the conncetion availible to any other session. Then when I ran it in a batch to do a simple file copy the net use command succeeded but the copy failed. When I used impersonate it did not change the user from NT AUTHORITY/? I can't a channel opened.

Cory

Need Novell Network Connection without logging on first

I am new to SSIS but this does not seem like it should be a hard thing to do. Here is the background:

Windows Server 2003

SQL Server 2005

SSIS

Logged in to server as Admin

I've created a SSIS package that I want to run as a Job. In it there is a Ole DB Connection to a VFP Database on a Novell Server. Client for Netware Services is started when server is but NOT logged into. When I created the package everything runs fine. Note that I had to login when I created the Data Link. I can even run it from the SQL Server Package Store. As soon as I restart the server and try to run it I get an error that the file path is invalid in both SSIS and the Package Store. I check the connection string and it looks good.

The connection is availible in My Network Places

If I open the connection and login it runs fine again.

How do I intiate the network connection and then close it again?

Cory Bonallo

Retail Services

Developer

Aren't there some NET USE commands (or NetWare equivalents) that you could use to create the connection without having to log in?
|||

I've never used anything like that. Should there be a setting or something in the SSIS connection manager? Do you have any examples? Thanks for your help!

Cory Bonallo

Retail Services

Developer

|||

Cory Bonallo wrote:

I've never used anything like that. Should there be a setting or something in the SSIS connection manager? Do you have any examples? Thanks for your help!

No, this is more in the Windows arena than SSIS. Taking the Novell client out of the picture for the moment, when you're not logged into the machine, none of your drive mappings are active since those are user-specific. Your package may work fine when you're logged it, but when it tries to run unattended with nobody logged in, it can no longer access mapped drives and fails.

This comes up from time to time here on the forum, but the search is failing me at the moment for good threads. This one applies, but isn't a stellar example.

With the Windows client, the NET USE command (try "net use /?" from the Windows command prompt) can be used to make these connections. If you're running the SSIS package from SQL Agent, you can use CmdExec steps before your package to create a connection with NET USE and one after the package to delete it.

I have no idea how having the NetWare client in the picture might change things. I don't know if NET USE will work or if there is a different command you have to use to accomplish this.

|||

Well I thought that did it. But now I can't get it to run in a job step. I cant seem to figure out the syntax or something for cmdExec.

Here is what I did:

in dos window typed "net use \\jds1\vol3 /user:admin" works great!

Created a job step as Operating System (cmd Exec) and typed in:

"net use" \\jds1\vol3 /user:admin

Got this error:

04/16/2007 11:05:45,fred,Error,1,TESTSERVER,fred,Open Novell Connection,,Executed as user: JENSENNT1\CORYB. The process could not be created for step 1 of job 0x7FE4E946E4D7E944A13A2AB6551A270B (reason: The system cannot find the file specified).The step failed.,00:00:00,0,0,,,,0

So I tried several other changes and still same error...

What am I missing?

Cory

|||Try:

"C:\WINDOWS\system32\net.exe" use \\server\share /user:admin

"net use" is not a command. "use" is an argument to net.exe.|||

Thank you Phil. The more I use this tool the dumber I feel! So now I don't get an error but it just sits on that step. I'm assuming it has something to do with a return success code. Try as I might I just can't find any examples or instructions on how to code for this. Is there a way to reture a success code. I left it a zero because the articles I found said that was the default success code. Agail thanks for your help!

Cory

|||

Cory Bonallo wrote:

Thank you Phil. The more I use this tool the dumber I feel! So now I don't get an error but it just sits on that step. I'm assuming it has something to do with a return success code. Try as I might I just can't find any examples or instructions on how to code for this. Is there a way to reture a success code. I left it a zero because the articles I found said that was the default success code. Agail thanks for your help!

Cory

I don't think its related to the return code. I think it probably isn't returning. I see you're specifying a user name but no password. The Net.exe may be prompting and waiting for a response. Try passing the password too.

"C:\WINDOWS\system32\net.exe" use \\server\share /user:admin mypassword

|||

You were right. It was the password. Now can you tell me why the connection is not persisting to the next job step? So here is what I want to do:

Step 1: open network connection

Step 2: run dtsx package that uses that connection

Step 3: Close network connection

Seems simple enough?

Cory

|||Look at either mapping a drive to that share, or using the /PERSISTENT:YES flag.|||

Phil Brammer wrote:

Look at either mapping a drive to that share, or using the /PERSISTENT:YES flag.

Or combining all three into a single step? Perhaps by putting them in a batch file?
|||

JayH wrote:

Or combining all three into a single step? Perhaps by putting them in a batch file?

Yep.|||

Thabk you both very much. What I ended up doing is adding an Excute Process Task to Open the connection, run the rest of the steps of the package and then close the connection. Thanks again to all!!!

Cory

|||

I did get the net use working in the Job as a part of an SSIS package. Now I am trying to use the same process to open a connection to Novell in the Query editor and setting up a stored procedure that a Web service can call to get a connection to an access.mdb linked server on the Novell drive. When I try to execute via xp_cmdshell the command succeeds but does not make the conncetion availible to any other session. Then when I ran it in a batch to do a simple file copy the net use command succeeded but the copy failed. When I used impersonate it did not change the user from NT AUTHORITY/? I can't a channel opened.

Cory

|||

I did get the net use working in the Job as a part of an SSIS package. Now I am trying to use the same process to open a connection to Novell in the Query editor and setting up a stored procedure that a Web service can call to get a connection to an access.mdb linked server on the Novell drive. When I try to execute via xp_cmdshell the command succeeds but does not make the conncetion availible to any other session. Then when I ran it in a batch to do a simple file copy the net use command succeeded but the copy failed. When I used impersonate it did not change the user from NT AUTHORITY/? I can't a channel opened.

Cory

Need list of known bugs when running SQL Server Reporting Services

Hi,
We are trying to document a list of known bugs when running SQL Server
Reporting Services on Windows 2000 server OS. If anyone can give us any
pointers on where we can get such a list please let us know.
mail me your reply at gaurav_maheshwari01@.infosys.com
Regards,
Gaurav MaheshwariI am not aware of a published list. Plus your request is pretty silly. Are
you talking RS 2000 or RS 2005. If RS 2000 with what service pack.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Gaurav Maheshwari" <Gaurav Maheshwari@.discussions.microsoft.com> wrote in
message news:5F6ABB2E-7A07-4C60-A5C3-5D137EECB26E@.microsoft.com...
> Hi,
> We are trying to document a list of known bugs when running SQL Server
> Reporting Services on Windows 2000 server OS. If anyone can give us any
> pointers on where we can get such a list please let us know.
> mail me your reply at gaurav_maheshwari01@.infosys.com
> Regards,
> Gaurav Maheshwari
>|||Hi Bruce,
Thanks for your reply. We are using RS 2000 along with SP4. We want to use
it in Windows 2000 server environmant. For that we need the list on Known
bugs.
Gaurav Maheshwari
SE, Infosys Tech. Ltd.
"Bruce L-C [MVP]" न� लि�ा:
> I am not aware of a published list. Plus your request is pretty silly. Are
> you talking RS 2000 or RS 2005. If RS 2000 with what service pack.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Gaurav Maheshwari" <Gaurav Maheshwari@.discussions.microsoft.com> wrote in
> message news:5F6ABB2E-7A07-4C60-A5C3-5D137EECB26E@.microsoft.com...
> >
> > Hi,
> >
> > We are trying to document a list of known bugs when running SQL Server
> > Reporting Services on Windows 2000 server OS. If anyone can give us any
> > pointers on where we can get such a list please let us know.
> > mail me your reply at gaurav_maheshwari01@.infosys.com
> > Regards,
> > Gaurav Maheshwari
> >
>
>|||Gaurav,
no software vendor anywhere in the world publishes anything like a
reasonable list of known bugs to users of their software....the
closest you come to this is known fixes...it is not in the software
vendors interest to publish such things...
Peter|||Hi Gaurav,
As of Now there is no sp4 for sql rs2000. only sp2 is available for
rs2000.
Peter Nolan wrote:
> Gaurav,
> no software vendor anywhere in the world publishes anything like a
> reasonable list of known bugs to users of their software....the
> closest you come to this is known fixes...it is not in the software
> vendors interest to publish such things...
> Peter|||Hi Gaurav,
As of Now there is no sp4 for sql rs2000. only sp2 is available for
rs2000.
Peter Nolan wrote:
> Gaurav,
> no software vendor anywhere in the world publishes anything like a
> reasonable list of known bugs to users of their software....the
> closest you come to this is known fixes...it is not in the software
> vendors interest to publish such things...
> Peter

Need information on syspermissions table

I have a MS Sqlserver 2000 database installed on my Windows NT4 PC.

After I granted permissions to a user for a specific table my Java code
(using JDBC - ODBC) was successfully able to retrieve the contents of the
table. However, when I examined the contents of the "syspermissions" table
using the following command :

osql /U sa /P /d %1 /w 256 -Q "select grantee,grantor,actadd,actmod,
(select substring(name,1,40)
from sysobjects where sysobjects.id = syspermissions.id) 'objname'
from syspermissions,sysobjects where
(sysobjects.xtype = 'U' and sysobjects.id = syspermissions.id) order by objname"

I did not see any difference in the entry for the table to which I granted
the access.

According to the documentation I have read the "syspermissions" table is the
place where access rights information is stored.

Am I missing something ? Where is the info on granted access rights stored
if not in the "syspermissions" table ?

Thanks for any help you can give.Q1 Thanks for any help you can give.

A1 GRANT and DENY statements populate sysprotects (which you have not queried). You may wish to consider using exec sp_helprotect instead?

Example:

Use Pubs
Go

exec sp_helprotect
@.name = 'Authors'
Go

exec sp_helprotect
@.name = 'Authors',
@.username = 'SomeOtherUser' ,
@.grantorname = NULL,
@.permissionarea = 's'
Go

NEED HELP:cannot run sql server 7.0 on windows 98

Hello !
I've installed SQL Server 7 Desktop on my computer (Windows 98).
(French version)
It has been complicated and long to get the SQL Server Services list
installed with SQL Server Services Manager. But I finally got it !!
I thought that whis this SQL Server was full ready to start.
But now, when I try to start SQL Server, it tries to start, but stop
immediatly.
When I try to open a SQL Server group with Enterprise Manager, it
returns me an error "ConnectionOpen (RPCopen...)". If SQL Server was
ready to start, it would open automatically.
So that's obvious SQL Server is not correctly installed...
I installed SQL Server 7.0 once two years ago and I did it
successfully whith a same configuration (Desktop 7.0 with Windows 98).
But I remember it had been difficult. And I didn't save anything about
what I did.
What do I have to do to complete SQL Server installation '?
Thanks for your help !So you start the SQL Server service and it stops again immediately? Then
check the SQL Server errorlog file and eventlog for error messages.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"bilou" <loghara@.yahoo.fr> wrote in message
news:9aac58ce.0311130811.33e86ea3@.posting.google.com...
> Hello !
> I've installed SQL Server 7 Desktop on my computer (Windows 98).
> (French version)
> It has been complicated and long to get the SQL Server Services list
> installed with SQL Server Services Manager. But I finally got it !!
> I thought that whis this SQL Server was full ready to start.
> But now, when I try to start SQL Server, it tries to start, but stop
> immediatly.
> When I try to open a SQL Server group with Enterprise Manager, it
> returns me an error "ConnectionOpen (RPCopen...)". If SQL Server was
> ready to start, it would open automatically.
> So that's obvious SQL Server is not correctly installed...
> I installed SQL Server 7.0 once two years ago and I did it
> successfully whith a same configuration (Desktop 7.0 with Windows 98).
> But I remember it had been difficult. And I didn't save anything about
> what I did.
> What do I have to do to complete SQL Server installation '?
> Thanks for your help !

Need help: With Dutch regional options, MS SQL Server BCP incorrectly delivers v

Hi all,

With Windows regional options are set to Dutch/Netherlands (or any other country using comma as the decimal symbol), MS SQL Server BCP Delivers incorrect figures to the target table.

The source table is a text file containing commas as the decimal character (As an example, in the text file 100.000 is represented as 100,000).

The target table is a Sql Server database table, with the column in question defined as a FLOAT datatype.

When BCP is run to deliver the data from the text file to Sql Server,
all figures are multiplied by 1000 because the input file for BCP contains a comma as the decimal symbol.

Thus, instead of the data being delivered with a value of 100, it ends up having a value of 100000

Is there anyone out there who is aware of any command line parameters that can be added to the bcp command in order to avoid this ? Note, the field in question is defined as SQLCHAR in the BCP format file.

Thanks for any help anyone may be able to offer.Second try on this one, does anyone have any possible suggestions ?

thanks again.|||What's the collation set to?

Mayb if you bcp the data to a staging table with a column a varchar then use replace?

Or divide by 1000 after the load?

Never had this problem