Creation of a Setup Project

Is possible to create a Setup Project of a Reporting Services Project to install it in another Server ?
You may be better asking this Q in the reporting services newsgroup as this
group deals with Replication.
"Asphart" <anonymous@.discussions.microsoft.com> wrote in message
news:EA5A329A-9D6D-4E75-9721-4691A19E8A68@.microsoft.com...
> Is possible to create a Setup Project of a Reporting Services Project to
install it in another Server ?

creating system dsn to SQL server 2000 Sp 4 fails

Hi,

I hope someone can help me out here? I have a fresh install of SQL Server 2000 (standard edition - sp4), on a server running Windows 2003 SE (v 5.2.3790). I am trying to create a system dsn on my client pc (running Windows 2000) to a newly created database in SQL server called BLISS.

I am getting the following error message:

Connection failed:

SQL State :'01000'

SQL Server Error: 11001

[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Connection Open (Connect()).

Connection Failed:

SQL State :'08001'

SQL Server Error: 6

[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not found.

From support.microsft.com I have tried changing the TCPPort value to 0, but this has not helped. Does anyone have any further ideas please?

Jackie

Which protocols are enabled? Have you tried running cliconfg.exe?|||

Hi Anton,

I have looked at cliconfg.exe and have enabled TCP/IP and named pipes for genera connections. Both were already enabled for connections to this SQL Server installation.

Another thought is that the connection works top a server running SQL Server 2k sp 3a, but not to this server running SQL Server 2k sp4. Perhaps I should just reinstall and put sp3a on instead?

Jackie

|||Have you already exhausted all the possibilities mentioned in http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=362498&SiteID=1

creating system dsn to SQL server 2000 Sp 4 fails

Hi,

I hope someone can help me out here? I have a fresh install of SQL Server 2000 (standard edition - sp4), on a server running Windows 2003 SE (v 5.2.3790). I am trying to create a system dsn on my client pc (running Windows 2000) to a newly created database in SQL server called BLISS.

I am getting the following error message:

Connection failed:

SQL State :'01000'

SQL Server Error: 11001

[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Connection Open (Connect()).

Connection Failed:

SQL State :'08001'

SQL Server Error: 6

[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not found.

From support.microsft.com I have tried changing the TCPPort value to 0, but this has not helped. Does anyone have any further ideas please?

Jackie

Which protocols are enabled? Have you tried running cliconfg.exe?|||

Hi Anton,

I have looked at cliconfg.exe and have enabled TCP/IP and named pipes for genera connections. Both were already enabled for connections to this SQL Server installation.

Another thought is that the connection works top a server running SQL Server 2k sp 3a, but not to this server running SQL Server 2k sp4. Perhaps I should just reinstall and put sp3a on instead?

Jackie

|||Have you already exhausted all the possibilities mentioned in http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=362498&SiteID=1sql

creating SQL at setup

I must install web applications on many servers
how can I create a MS SQL database at setup ?

thank youOne option is to script the db and use OSQL to execute the script.|||what is OSQL ?|||By using osql utility, you can run sql commands from command prompt.

You can run batch scripts that are saved in a text file, and also save the returned results in a text file.|||yes ... that's so unpracticle comparing to access :-))

thank you

Creating multiple databases running off the same Data Engine

Hi, I have looked and loked for the answer to this question and made no progress.
I want to install MSDE on one of our servers, however, when I went to install it, I found that there was another MSDE already installed and running (it was an agent running with our backup software Veritas). Is it alright to create another database and have 2 running simultaneous on the same data engine? Is there any type of limitations that I sould know about - such as number of allowed accesses at one time? Any help is greatly appreicated.You can create another database with the existing MSDE but if you are on a large network I would install another instance and get the Developer edition to manage them that way you will avoid the risk of running your application on MSDE that is already used to the max in system resources. I have seen SQL Server running without databases because it is used to run xp_cmdshell to move data from DB2 AS400 to live SQL Server on the web about four hours a day. Try the link below to buy the Developer edition. When you have installed the Developer edition you right click at the top of Enterprise manager and register both. Hope this helps.
http://www.provantage.com/buy-22053391-microsoft-backoffice-sql-server-2000-developer-edition-shopping.htm

Creating Instance of SQL 2000

I installed SQL 2000 server and I didn't install an instance of it (at least I don't think so). How would I install an instance now?My understanding of your question is that you already have a default instance of SQL Server in your box and now want to install one more named instance to it.

If my understanding is right, then what you have to do is to start the SQL Server installation procedure and after some 3 or 4 steps, the installation program will ask you whether you want to create a new named instance, at that point you have to select named instance and then enter a name for your new instance.|||Well I have an instance of SQL Express 2005. I want to install a SQL Server 2000 instance, which would be my first instance of an SQL Server 2000, do I need hte CD?

Creating Database

I just installed the SQL into my SBS2000 server. The reason why i'm doing this is i'm trying to install MS Project Central Server. Anyway, i'm following the directions off MS and i'm came across a problem. I'm trying to create the database, tables and fie
lds by using the 'osql' command. I'm getting an error off the first command that i'm using.
Command: osql -U <account name> -P <password> -i Crttable.sql
Error: [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.
Any idea what the problem might be?
Thanks! Mike
Look at the SQL Server errorlgo and verify that the shared memory protocol
is loaded. You should see something that says:
SQL Server listening on Shared Memory, TCP and Named pipes.
If Shared Memory is missing that could explain the problem.
Rand
This posting is provided "as is" with no warranties and confers no rights.

Creating Database

I just installed the SQL into my SBS2000 server. The reason why i'm doing th
is is i'm trying to install MS Project Central Server. Anyway, i'm following
the directions off MS and i'm came across a problem. I'm trying to create t
he database, tables and fie
lds by using the 'osql' command. I'm getting an error off the first command
that i'm using.
Command: osql -U <account name> -P <password> -i Crttable.sql
Error: [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Ser
ver does not exist or access denied.
Any idea what the problem might be'
Thanks! MikeLook at the SQL Server errorlgo and verify that the shared memory protocol
is loaded. You should see something that says:
SQL Server listening on Shared Memory, TCP and Named pipes.
If Shared Memory is missing that could explain the problem.
Rand
This posting is provided "as is" with no warranties and confers no rights.