Credentials for Data Sources - Changing Authentication

I have Visual Studio installed on my local laptop, as well as on the report server. The only place reporting services is installed is on the report server.

I have a solution called “Performance Monitoring”, and within that solution is a report of the same name. That report uses 2 data sets, “DSOne” and “DSTwo” and these data sets are pulled from 2 shared data sources. I can edit the report locally and preview it just fine and the results are what we’re looking for.

Right now, the data sources are all set to Windows authentication. We would like to tie the data sources to a specific user ID and password, so that I or anybody else is able to view the report without having to have a separate login for all those people. I have tried changing the data sources' properties in Visual Studio to reflect using a specific login/pass (my own). I have tried this in Report Manager too – editing the data sources there to use my login and pass. Both of these methods have not worked.

In Visual Studio, in the Solution Explorer, I double click on one of the data sources and go to the credentials tab. “Use Windows Authentication” is checked, so I check “use a specific user name and password” instead and then enter my login and password. When I try to preview the report, it gives me the following error and I am stumped as to why this is:

“An error has occurred during report processing. Cannot create a connection to data source “DSTwo”. Login failed for user “xxx”.”

I have also tried editing the login and password through the “edit” button on the “general” tab of whatever data source I’m working with. The “Use Windows NT Integrated Security” box is checked, so I check the “Use a Specific Name and Password” box and again, type in my login info. When I hit “Test Connection”, I get the following:

“Test connection failed because of an error in initializing provider. Login failed for user ‘xxx.”

Hopefully this provided enough detail as to what the heck is going on here. I’ve been playing with these processes for a few days and for whatever reason, it is not working. I’m hoping somebody may have some insight as to why this is.

Thanks,
Matt

If you're using stored windows credentials, you need to check the "use as windows credentials" checkbox on the data source properties page.

-Lukasz

Credentials for Data Sources - Changing Authentication

I have Visual Studio installed on my local laptop, as well as on the report server. The only place reporting services is installed is on the report server.

I have a solution called “Performance Monitoring”, and within that solution is a report of the same name. That report uses 2 data sets, “DSOne” and “DSTwo” and these data sets are pulled from 2 shared data sources. I can edit the report locally and preview it just fine and the results are what we’re looking for.

Right now, the data sources are all set to Windows authentication. We would like to tie the data sources to a specific user ID and password, so that I or anybody else is able to view the report without having to have a separate login for all those people. I have tried changing the data sources' properties in Visual Studio to reflect using a specific login/pass (my own). I have tried this in Report Manager too – editing the data sources there to use my login and pass. Both of these methods have not worked.

In Visual Studio, in the Solution Explorer, I double click on one of the data sources and go to the credentials tab. “Use Windows Authentication” is checked, so I check “use a specific user name and password” instead and then enter my login and password. When I try to preview the report, it gives me the following error and I am stumped as to why this is:

“An error has occurred during report processing. Cannot create a connection to data source “DSTwo”. Login failed for user “xxx”.”

I have also tried editing the login and password through the “edit” button on the “general” tab of whatever data source I’m working with. The “Use Windows NT Integrated Security” box is checked, so I check the “Use a Specific Name and Password” box and again, type in my login info. When I hit “Test Connection”, I get the following:

“Test connection failed because of an error in initializing provider. Login failed for user ‘xxx.”

Hopefully this provided enough detail as to what the heck is going on here. I’ve been playing with these processes for a few days and for whatever reason, it is not working. I’m hoping somebody may have some insight as to why this is.

Thanks,
Matt

If you're using stored windows credentials, you need to check the "use as windows credentials" checkbox on the data source properties page.

-Lukasz

Creating user

Hi,
I've just installed MSDE, and I'm wondering how to create user so I
don't have to login as 'sa' user.
Thanks in advance
ukasz
Try:
sp_addlogin '<userName','<password>'
Look for sp_addlogin / sp_grantlogin in the BOL.
HTH, Jens Suessmeyer.
|||Hi,
To add on Jens:-
MSDE will not come with GUI tools; so you need to login using OSQL to sql
server and issue TSQL commands to create Logins and users.
For eg; if you need to create a user HARI with read only rights in Finance
database then:-
From command line:-
OSQL -S <servername> -Usa -P<sapassword> (enter)
SP_addlogin 'hari','haripass'
go <enter>
Use Finance
go <enter>
sp_adduser 'hari'
go <enter>
sp_addrolemember 'db_datareader','hari'
go <enter>
he above commands will create user Hari with read rights in Finance
database.
Thanks
Hari
SQL Server MVP
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1126692828.991504.289480@.g47g2000cwa.googlegr oups.com...
> Try:
> sp_addlogin '<userName','<password>'
> Look for sp_addlogin / sp_grantlogin in the BOL.
> HTH, Jens Suessmeyer.
>
|||Hari Prasad wrote:
> Hi,
> To add on Jens:-
> MSDE will not come with GUI tools; so you need to login using OSQL to sql
> server and issue TSQL commands to create Logins and users.
> For eg; if you need to create a user HARI with read only rights in Finance
> database then:-
> From command line:-
> OSQL -S <servername> -Usa -P<sapassword> (enter)
> SP_addlogin 'hari','haripass'
> go <enter>
> Use Finance
> go <enter>
> sp_adduser 'hari'
> go <enter>
> sp_addrolemember 'db_datareader','hari'
> go <enter>
> he above commands will create user Hari with read rights in Finance
> database.
> Thanks
> Hari
> SQL Server MVP
>
>
> "Jens" <Jens@.sqlserver2005.de> wrote in message
> news:1126692828.991504.289480@.g47g2000cwa.googlegr oups.com...
>
>
Thanks.
|||Hari Prasad wrote:
> Hi,
> To add on Jens:-
> MSDE will not come with GUI tools; so you need to login using OSQL to sql
> server and issue TSQL commands to create Logins and users.
> For eg; if you need to create a user HARI with read only rights in Finance
> database then:-
> From command line:-
> OSQL -S <servername> -Usa -P<sapassword> (enter)
> SP_addlogin 'hari','haripass'
> go <enter>
> Use Finance
> go <enter>
> sp_adduser 'hari'
> go <enter>
> sp_addrolemember 'db_datareader','hari'
> go <enter>
> he above commands will create user Hari with read rights in Finance
> database.
> Thanks
> Hari
> SQL Server MVP
>
>
> "Jens" <Jens@.sqlserver2005.de> wrote in message
> news:1126692828.991504.289480@.g47g2000cwa.googlegr oups.com...
>
>
Thanks
ukasz

Creating stored procedures in sql server

I just installed sql server 2005 on my machine. I've been using Access for some time and have created my stored procedures easily in it. However, this sql server 2005 is so complicated. In Access, all I had to do was "Create a New Query", write my sql statement, name and save it.

However, I am having so much trouble with this sql server. For example, when I create a stored procedure in sql server, it has a .sql extension. I am assuming the stored procedure is a file. However, after saving it, I expand my database, expand programmability, and expand stored procedures, yet my new stored procedure is not there. It's placed in a file called projects. I need to access this stored procedure from code, but in visual studio, I get an error message, "Cannot find stored procedure sp_Roster".

Here is the code I used to access my stored procedure from vb.net. I thought it would work but it didnt

Dim comm As New SqlCommand
Dim strsql As String
Dim strconn As String
strsql = "sp_Roster"
strconn = "server=Home; user=sa; pwd=juwar74; database=Book;"
With comm
.Connection = New SqlConnection(strconn)
.CommandText = strsql
.CommandType = CommandType.StoredProcedure
With .Parameters.Add("TeacherID", SqlDbType.Char)
.Value = "DawsMark@.aol.com"
End With
With .Parameters.Add("ClassID", SqlDbType.Int)
.Value = CInt(classid)
End With
With .Parameters.Add("sID", SqlDbType.Int)
.Value = ssID
End With
With .Parameters.Add("sLastName", SqlDbType.Char)
.Value = lastname
End With
With .Parameters.Add("sFirstName", SqlDbType.Char)
.Value = firstname
End With
With .Parameters.Add("sMiddleName", SqlDbType.Char)
.Value = middlename
End With
With .Parameters.Add("Student", SqlDbType.Char)
.Value = fullname
End With
With .Parameters.Add("Password", SqlDbType.Char)
.Value = password
End With
.Connection.Open()
.ExecuteNonQuery()
With comm.Connection
If .State = ConnectionState.Open Then
.Close()
End If
End With
End With

Here is my procedure that I created and that was saved as sp_Roster.sql in sql server

CREATE PROCEDURE sp_Roster

AS
BEGIN

SET NOCOUNT ON;

-- Insert statements for procedure here
INSERT INTO Roster (TeacherID, ClassID, sID, sLastName, sFirstName, sMiddleName, Student, Password) VALUES (@.TeacherID, @.ClassID, @.sID, @.sLastName, @.sFirstName, @.sMiddleName, @.Student, @.Password)
END
GO

Why isn't ado.net finding it in sql server. Is the sqlstr correct?

In order to save a stored procedure to the DB in SQL 2005 you need to execute this code instead of saving the text as a file. Just click the "Execute" button and you should be ok. Another thing however, is that you have not declared your variables. You will not be able to execute/save your stored procedure without this.

CREATEPROCEDURE sp_Roster

@.TeacherIDint,

@.ClassIDint,

@.sIDint,

@.sLastNamenvarchar(100),

@.sFirstNamenvarchar(100),

@.sMiddleNamenvarchar(50),

@.Studentnvarchar(100),

@.Passwordnvarchar(100)

AS

BEGIN

SETNOCOUNTON;

-- Insert statements for procedure here

INSERTINTO Roster(TeacherID, ClassID,sID, sLastName, sFirstName, sMiddleName, Student,Password)VALUES(@.TeacherID, @.ClassID, @.sID, @.sLastName, @.sFirstName, @.sMiddleName, @.Student, @.Password)

END

GO

|||

Unfortunately, Sql Server doesn't work the same as Access in this way. Wehn you save a query in Sql Server, you are saving the query, but no the query to the database. The script has to be run to actually create your stored procedure. This can be done by pressing F5. However, your query itself needs some work as you have no input parameters to your stored procedure.

sql

Creating Simple Report using Reporting Services SP2 and SharePoint 2007 Integration

I've been running around in circles all afternoon trying to create one simple report using Reporting Services (with latest SP2 installed) and SharePoint 2007. To the best of my knowledge, I have everything configured correctly:

When I access http://<server>/ReportServer, I see the server name of my SharePoint site.

When I click on the name of my SharePoint site, it shows me the directory structure I have created within my SharePoint Site

When I drill down in the directory, I can ultimately see the forms I created in my forms library (created via InfoPath 2007).

The next step is to create one simple report from the data in one of these forms libraries and a report on all the items within a form library. I'm stuck at the first step of creating a report, namely what to enter as the Data Source and the connection string. With a SQL database this isn't an issue.

How does one create a data source that will allow reporting over SharePoint content with the setup described above? And, if you have information that is found in the SQL Books Online, please be kind and post links so others know where to find this information.

You may want to check out this thread on how to use a SharePoint list as a Datasource:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1154115&SiteID=1

HTH
Prash

|||

I've looked at that thread many times and was able to extract information from a list using web services. But, with Reporting Services SP2 integration with SharePoint 2007, I figured they would have included built-in support to create reports in BIDS that consume SharePoint Lists and Document Libraries.

Perhaps I'm not seeing the full extent to which Reporting Services SP2 integration is supposed to act. My thoughts were that a SharePoint integration mode would allow reports to not only be stored on SharePoint sites, but also allow reports to be about the SharePoint site itself.

|||

Reporting Services SP2 integration with SharePoint 2007 does not include built-in support for consuming SharePoint Site data to be displayed in a Report.

thanx,
Prash

|||

I tried to workaround this issue

by Creating Microsoft Access 2007 Database, using Linked SharePoint List as a tables, then I created Reporting Service Report Using this Database, in Visual Studio the Report is working fine by showing the data correctly but when you try it on the report server reporsitory directly or in the Windows SharePoint Service 3 site It doesn't work at all, it keep loading and loading until the error unexpected error appear if am running it from the sharepoint site. even thougth I configured the data sources correctly in sharepoint for the report

Any help on that

Thanks

Mohd

|||

Hi,

You may be interested by our Reporting Services Data Extension : ERSDE that lets you build reports using SharePoint lists.

Though it was initially built for SPS 2003/WSS V2 lists, most of the features still work with MOSS 2007/WSS V3. We will soon release an update for Moss 2007/Wss V3.

Frdric Latour

Enesys

Creating Simple Report using Reporting Services SP2 and SharePoint 2007 Integration

I've been running around in circles all afternoon trying to create one simple report using Reporting Services (with latest SP2 installed) and SharePoint 2007. To the best of my knowledge, I have everything configured correctly:

When I access http://<server>/ReportServer, I see the server name of my SharePoint site.

When I click on the name of my SharePoint site, it shows me the directory structure I have created within my SharePoint Site

When I drill down in the directory, I can ultimately see the forms I created in my forms library (created via InfoPath 2007).

The next step is to create one simple report from the data in one of these forms libraries and a report on all the items within a form library. I'm stuck at the first step of creating a report, namely what to enter as the Data Source and the connection string. With a SQL database this isn't an issue.

How does one create a data source that will allow reporting over SharePoint content with the setup described above? And, if you have information that is found in the SQL Books Online, please be kind and post links so others know where to find this information.

You may want to check out this thread on how to use a SharePoint list as a Datasource:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1154115&SiteID=1

HTH
Prash

|||

I've looked at that thread many times and was able to extract information from a list using web services. But, with Reporting Services SP2 integration with SharePoint 2007, I figured they would have included built-in support to create reports in BIDS that consume SharePoint Lists and Document Libraries.

Perhaps I'm not seeing the full extent to which Reporting Services SP2 integration is supposed to act. My thoughts were that a SharePoint integration mode would allow reports to not only be stored on SharePoint sites, but also allow reports to be about the SharePoint site itself.

|||

Reporting Services SP2 integration with SharePoint 2007 does not include built-in support for consuming SharePoint Site data to be displayed in a Report.

thanx,
Prash

|||

I tried to workaround this issue

by Creating Microsoft Access 2007 Database, using Linked SharePoint List as a tables, then I created Reporting Service Report Using this Database, in Visual Studio the Report is working fine by showing the data correctly but when you try it on the report server reporsitory directly or in the Windows SharePoint Service 3 site It doesn't work at all, it keep loading and loading until the error unexpected error appear if am running it from the sharepoint site. even thougth I configured the data sources correctly in sharepoint for the report

Any help on that

Thanks

Mohd

|||

Hi,

You may be interested by our Reporting Services Data Extension : ERSDE that lets you build reports using SharePoint lists.

Though it was initially built for SPS 2003/WSS V2 lists, most of the features still work with MOSS 2007/WSS V3. We will soon release an update for Moss 2007/Wss V3.

Frdric Latour

Enesys

creating server alias without Client Tools installed?

Hi All: What is the MDAC application that allows you to create server
aliases if you don't have Client Tools installed?
sorry...I was looking for "cliconfg.exe"
"geek-y-guy" <noone@.nowhere.com> wrote in message
news:eQFUPOCHGHA.1628@.TK2MSFTNGP12.phx.gbl...
> Hi All: What is the MDAC application that allows you to create server
> aliases if you don't have Client Tools installed?
>

Creating reports?

I have installed VB 2003 but don't see a project option for Business
Intelligence Projects? How do I get this installed as I need to create MS
Operation Manager 2005 reports?BIDS does not exist pre-SS2005. You need to manually create your own
solution/project/report files.
"Gonzo" wrote:
> I have installed VB 2003 but don't see a project option for Business
> Intelligence Projects? How do I get this installed as I need to create MS
> Operation Manager 2005 reports?
>
>|||Hi,
You should install the SSRS 2000 client tool, then it will be in your Visual
Studio under Business Inteligence Project. I did it before using VS2005 and
SQL Server 2005.
Regards,
Janos
"William" <William@.discussions.microsoft.com> wrote in message
news:C9920E58-DB39-466D-9A2D-DC28CCA70136@.microsoft.com...
> BIDS does not exist pre-SS2005. You need to manually create your own
> solution/project/report files.
> "Gonzo" wrote:
>> I have installed VB 2003 but don't see a project option for Business
>> Intelligence Projects? How do I get this installed as I need to create
>> MS
>> Operation Manager 2005 reports?
>>

Creating Reports

What needs to be installed on a workstation in order to be able to create
reports for reporting services?
I have Visual Studio .NET installed, and having installed the reporting
services client noticed it had appeared as an option in VS.
A colleague installed the reporting services client who didn't have Visual
Studio .NET and doesn't seem to have the ability to create a report.You need VS. I've read here about other software to generate the RDL,
but VS makes it much nicer.

Creating Report using Visual Web Developer 2005 Express with SQL 2005 Reporting Services A

Hi

I am wanting to learn how to create a Report using SQL 2005 Reporting Services, I use Visual Web Developer 2005 Express and have installed the Reporting Services Add-In for Visual Web Developer 2005 Express.

Does anyone here know of any good step-by-step tutorials on how to get started creating the reports. As I want something to go through how to create the datasource right through to creating / formating the report ready for use.

Matthew

This links might help you:

http://technoblab.blogspot.com
http://www.databasejournal.com
http://www.codeproject.com/aspnet/ReportViewer.asp

Creating new users with MSDE

I have MSDE installed on my sistem, and I need to add a new user.
How do I go about doing this?Hi,

MSDE do not have user interface thus all manipulation can be done
using SQL-DMO and Visual Basic (Assume you are using VB6.0).

Add reference to "Microsoft SQL-DMO object librarary", in that you can
use login class to add login. In fact you can completely manage and
operate SQL Server/MSDE using SQL-DMO.

Hope this helps you.

Thanks, Amit

thirdmarshaleomer@.hotmail.com (Kyle) wrote in message news:<2d9cd550.0306271223.27e14f57@.posting.google.com>...
> I have MSDE installed on my sistem, and I need to add a new user.
> How do I go about doing this?|||if you have 19$ take a look at www.msde.biz

hth,
Helmut

"Kyle" <thirdmarshaleomer@.hotmail.com> schrieb im Newsbeitrag
news:2d9cd550.0306271223.27e14f57@.posting.google.c om...
> I have MSDE installed on my sistem, and I need to add a new user.
> How do I go about doing this?

Creating new backup device

I need to create a new backup device. I have installed a
USB drive, and would like to backup a database to it.
However, SQL Server can only see one of the drives
available on the machine when I try to create the new
device. How can I make a new backup device to a different
drive letter?
Can you try creating a dump device using sp_addumpdevice from Query Analyzer
and see if that solves the problem? See SQL Server Books Online for more
information.--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"onemoreshot" <anonymous@.discussions.microsoft.com> wrote in message
news:7fa201c484ae$4c09e7b0$a401280a@.phx.gbl...
I need to create a new backup device. I have installed a
USB drive, and would like to backup a database to it.
However, SQL Server can only see one of the drives
available on the machine when I try to create the new
device. How can I make a new backup device to a different
drive letter?
|||In other words, it can't be done through Enterprise
Manager? Thanks .

>--Original Message--
>Can you try creating a dump device using sp_addumpdevice
from Query Analyzer
>and see if that solves the problem? See SQL Server Books
Online for more
>information.--
>HTH,
>Vyas, MVP (SQL Server)
>http://vyaskn.tripod.com/
>
>"onemoreshot" <anonymous@.discussions.microsoft.com> wrote
in message
>news:7fa201c484ae$4c09e7b0$a401280a@.phx.gbl...
>I need to create a new backup device. I have installed a
>USB drive, and would like to backup a database to it.
>However, SQL Server can only see one of the drives
>available on the machine when I try to create the new
>device. How can I make a new backup device to a different
>drive letter?
>
>.
>
|||If it is a proper drive, then you should be able to do it in EM also. I am
just trying to narrow down the problem, by trying this in Query Analyzer.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
<anonymous@.discussions.microsoft.com> wrote in message
news:8be201c48592$81ec8f60$a401280a@.phx.gbl...
In other words, it can't be done through Enterprise
Manager? Thanks .

>--Original Message--
>Can you try creating a dump device using sp_addumpdevice
from Query Analyzer
>and see if that solves the problem? See SQL Server Books
Online for more
>information.--
>HTH,
>Vyas, MVP (SQL Server)
>http://vyaskn.tripod.com/
>
>"onemoreshot" <anonymous@.discussions.microsoft.com> wrote
in message
>news:7fa201c484ae$4c09e7b0$a401280a@.phx.gbl...
>I need to create a new backup device. I have installed a
>USB drive, and would like to backup a database to it.
>However, SQL Server can only see one of the drives
>available on the machine when I try to create the new
>device. How can I make a new backup device to a different
>drive letter?
>
>.
>

Creating multiple temporary databases.

Hello,
I noticed that when we installed SQL 2000 Reporting services that two
databases are created one being ReportServerTempDB. This got me to thinkin
g
about Oracle databases where I can create multiple temporary 'tablespaces'
and then I can assign specific users to specific tablespaces.
In a SQL environment, can I create separate tempdbs that will be used by
separate users and/or applications? How do Reporting Services use the
ReportServerTempDB?
I'm trying to create a shared hosting environment in my organization and
don't want competing applications filling up the tempdb. I'd much prefer
that each application uses it's own temp space.
Thanks!
Art"Art Decker" <ArtDecker@.discussions.microsoft.com> wrote in message
news:E8D4949F-A0C5-4408-8318-F58EF0847085@.microsoft.com...
> Hello,
> I noticed that when we installed SQL 2000 Reporting services that two
> databases are created one being ReportServerTempDB. This got me to
> thinking
> about Oracle databases where I can create multiple temporary 'tablespaces'
> and then I can assign specific users to specific tablespaces.
> In a SQL environment, can I create separate tempdbs that will be used by
> separate users and/or applications?
>How do Reporting Services use the ReportServerTempDB?
It uses it for caching and snapshots. Lots of reads and writes with a low
requirement for backup.
But it's an ordinary user database.

> I'm trying to create a shared hosting environment in my organization and
> don't want competing applications filling up the tempdb. I'd much prefer
> that each application uses it's own temp space.
>
All databases on a server share memory, CPU and TempDB. You can install
multiple instances to segregate these resources.
David

Creating multiple temporary databases.

Hello,
I noticed that when we installed SQL 2000 Reporting services that two
databases are created one being ReportServerTempDB. This got me to thinking
about Oracle databases where I can create multiple temporary 'tablespaces'
and then I can assign specific users to specific tablespaces.
In a SQL environment, can I create separate tempdbs that will be used by
separate users and/or applications? How do Reporting Services use the
ReportServerTempDB?
I'm trying to create a shared hosting environment in my organization and
don't want competing applications filling up the tempdb. I'd much prefer
that each application uses it's own temp space.
Thanks!
Art"Art Decker" <ArtDecker@.discussions.microsoft.com> wrote in message
news:E8D4949F-A0C5-4408-8318-F58EF0847085@.microsoft.com...
> Hello,
> I noticed that when we installed SQL 2000 Reporting services that two
> databases are created one being ReportServerTempDB. This got me to
> thinking
> about Oracle databases where I can create multiple temporary 'tablespaces'
> and then I can assign specific users to specific tablespaces.
> In a SQL environment, can I create separate tempdbs that will be used by
> separate users and/or applications?
>How do Reporting Services use the ReportServerTempDB?
It uses it for caching and snapshots. Lots of reads and writes with a low
requirement for backup.
But it's an ordinary user database.
> I'm trying to create a shared hosting environment in my organization and
> don't want competing applications filling up the tempdb. I'd much prefer
> that each application uses it's own temp space.
>
All databases on a server share memory, CPU and TempDB. You can install
multiple instances to segregate these resources.
David

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 and table on MS MSQL server

Hi All,
I want to use MS sql server edition 2000. I have installed the server. Now i
want to create the database on this server with tables and triggers. Can
please someone suggest me how to do this ?
Thanks a lot,
DineshCREATE DATABASE ...
CREATE TABLE ...
CREATE TRIGGER ...

Lookup these commands in Books Online

--
David Portas
SQL Server MVP
--

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.