Credential error when using SSPI

I have a SQL Server database that I am able to connect to using Visual
Studio 2005 Server Explorer. However, when I attempt to establish a
connection in a C# program using SSPI, I get a login failure using the same
credentials used with Server Explorer.
Does anyone know what might cause this?Double check and make sure that your connection string is spelled correctly.
I sometimes like using ODBC manager to double check to make sure the
connection works that way. It uses your windows credentials as does SSIS
should you choose to look at it that way.
thanks,
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/
"William" <nfr@.nospam.com> wrote in message
news:eR058I11GHA.1268@.TK2MSFTNGP02.phx.gbl...
>I have a SQL Server database that I am able to connect to using Visual
>Studio 2005 Server Explorer. However, when I attempt to establish a
>connection in a C# program using SSPI, I get a login failure using the same
>credentials used with Server Explorer.
> Does anyone know what might cause this?
>

Creating SSRS folders?

New ssrs istall.
When I attempt to open report manager, i just get
SQL Server Reporting Services
Home
with no option for creating a folder etc, like i have on development
When I attempt to deploy to ther server I get :
Deploying to http://amsqlclusterxx/reportserver/
Error rsItemAlreadyExists : The item '/Retailer' already exists.
How do I create an ssrs reports folder?
Also, and this is strange, but in vs.net I had to create a new shared
datasource after removing the old one on the report with the same
name. The report renders fine when I do an f5 pointing to a new
datasource, but I no longer have the RUN "!" icon available while in
the data tag to run my query. Why is this?
Thanks for any help or information.Hello,
I suppose that user which you use to connect to Report Manager has
insufficient permissions.
Check if this situation takes place also if you use user account which is a
member of the server's Administrators group (BUILTIN\Administrators).
Or maybe you have in IIS configured anonymouse access to Report Manager
Site.
Does RS ask for login credentials when you open Report Manager?
Best Regards,
Radoslaw Lebkowski
Uzytkownik "jobs" <jobs@.webdos.com> napisal w wiadomosci
news:1193850825.364868.47100@.19g2000hsx.googlegroups.com...
> New ssrs istall.
> When I attempt to open report manager, i just get
> SQL Server Reporting Services
> Home
> with no option for creating a folder etc, like i have on development
> When I attempt to deploy to ther server I get :
> Deploying to http://amsqlclusterxx/reportserver/
> Error rsItemAlreadyExists : The item '/Retailer' already exists.
> How do I create an ssrs reports folder?
> Also, and this is strange, but in vs.net I had to create a new shared
> datasource after removing the old one on the report with the same
> name. The report renders fine when I do an f5 pointing to a new
> datasource, but I no longer have the RUN "!" icon available while in
> the data tag to run my query. Why is this?
> Thanks for any help or information.
>

Creating Horizontal Partition

From a previous post I got an example of creating a Horizontal Partition. I have altered the code in an attempt to understand why the partition I want fails on insert. The altered script is:

create table Table_A_Jan (Col1 int not null, Col2 char(2) not null CHECK (col2 = 'RL')--CHECK (Col2 >= cast('20060101' as datetime) and Col2 < cast('20060201' as datetime))--,--Col3 char(5) not null, CONSTRAINT [PKJan] PRIMARY KEY CLUSTERED ([Col1], [Col2]/*, [Col3] */) WITH FILLFACTOR = 95 ON [PRIMARY] )

create table Table_A_Feb (Col1 int not null,Col2 datetime not null CHECK (col2 = 'RP') --(Col2 >= cast('20060201' as datetime) and Col2 < cast('20060301' as datetime))--,--Col3 char(5) not null, CONSTRAINT [PKFeb] PRIMARY KEY CLUSTERED ([Col1], [Col2]/*, [Col3]*/) WITH FILLFACTOR = 95 ON [PRIMARY] )

CREATE VIEW A AS SELECT * FROM Table_A_Jan

UNION ALL

SELECT * FROM Table_A_Feb

Then the insert

INSERT INTO A (Col1, Col2/*, Col3*/) VALUES (45, 'RL'--'2006-01-21 23:55:34.000'--, '00073' )

And the resulting error message

because the primary key of table '[AAAA].[dbo].[Table_A_Jan]' is not included in the union result.

As long as I keep Col2 as date time everything works. Why does it fail when I want the CHECK contraint to be equal to a particular string?

(Sorry about the font issue don't get what is going on here)

Andrew.

This forum where you will seek help for Analysis Services related questions. I know your quest started from exploring solutions for Analysis Services application, but looks like you missing some basic knowlege on relational databases (SQL Server and likes). I suggest you get yourself a good book or tutorial on how to work with SQL.

HTH

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

creating DDL from a temporary table

I need to write a DDL Create script for a table in TempDb.
In Query Analyzer, I can see the table, but when I right click on the table
and attempt to script the Create I get a message telling that it could not
find the object in the collection (and it suggests I may want to use
qualifiers).
In Enterprise Manager, I can not see any user talbes in TempDb.
How do I get the scripts, ie, the DDL Create syntax...besides writing it
myself.
I have about 30 views which need to be changed to tables
Thaniks
Materialize the table, then script it:
Select * INTO SomeMaterializedTable
From #YourTempTable
Where 1= 2 --To have no rows, only the structure
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Abroit" wrote:

> I need to write a DDL Create script for a table in TempDb.
> In Query Analyzer, I can see the table, but when I right click on the table
> and attempt to script the Create I get a message telling that it could not
> find the object in the collection (and it suggests I may want to use
> qualifiers).
> In Enterprise Manager, I can not see any user talbes in TempDb.
> How do I get the scripts, ie, the DDL Create syntax...besides writing it
> myself.
> I have about 30 views which need to be changed to tables
> Thaniks

creating DDL from a temporary table

I need to write a DDL Create script for a table in TempDb.
In Query Analyzer, I can see the table, but when I right click on the table
and attempt to script the Create I get a message telling that it could not
find the object in the collection (and it suggests I may want to use
qualifiers).
In Enterprise Manager, I can not see any user talbes in TempDb.
How do I get the scripts, ie, the DDL Create syntax...besides writing it
myself.
I have about 30 views which need to be changed to tables
ThaniksMaterialize the table, then script it:
Select * INTO SomeMaterializedTable
From #YourTempTable
Where 1= 2 --To have no rows, only the structure
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Abroit" wrote:
> I need to write a DDL Create script for a table in TempDb.
> In Query Analyzer, I can see the table, but when I right click on the table
> and attempt to script the Create I get a message telling that it could not
> find the object in the collection (and it suggests I may want to use
> qualifiers).
> In Enterprise Manager, I can not see any user talbes in TempDb.
> How do I get the scripts, ie, the DDL Create syntax...besides writing it
> myself.
> I have about 30 views which need to be changed to tables
> Thaniks

creating DDL from a temporary table

I need to write a DDL Create script for a table in TempDb.
In Query Analyzer, I can see the table, but when I right click on the table
and attempt to script the Create I get a message telling that it could not
find the object in the collection (and it suggests I may want to use
qualifiers).
In Enterprise Manager, I can not see any user talbes in TempDb.
How do I get the scripts, ie, the DDL Create syntax...besides writing it
myself.
I have about 30 views which need to be changed to tables
ThaniksMaterialize the table, then script it:
Select * INTO SomeMaterializedTable
From #YourTempTable
Where 1= 2 --To have no rows, only the structure
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Abroit" wrote:

> I need to write a DDL Create script for a table in TempDb.
> In Query Analyzer, I can see the table, but when I right click on the tabl
e
> and attempt to script the Create I get a message telling that it could not
> find the object in the collection (and it suggests I may want to use
> qualifiers).
> In Enterprise Manager, I can not see any user talbes in TempDb.
> How do I get the scripts, ie, the DDL Create syntax...besides writing it
> myself.
> I have about 30 views which need to be changed to tables
> Thaniks

Creating databases under MS SQL 2005 Server (SP-2): dbo user role

Good Day,

I am having a problem with creating databases in MS SQL 2005 Server. When I attempt to assign an User Mapping for my SQL user account to the newly created database, the "dbo" user and schema is already assigned. When I try to drop this user in favor of my own, I receive an error message: Cannot alter the user "dbo" (Microsoft SQL Server, Error: 15150). I am connected to my database engine through the "sa" account.

Regards,

Keith

Hi Keith,

The login that creates the database is mapped to a special user called dbo. The dbo is the owner of the database and can not be dropped. The dbo schema is associated with the dbo user so it also can not be dropped.

The sa account will represent itself as dbo in all databases.

to check for yourself: select user_name() when logged in as sa.

Hope this helps,

-Steven Gott

SDE/T

SQL Server

|||

I have a database that must have a unique schema and user account assigned. I want to exchange the default "dbo" user with my own.

Regards,

Keith

|||

Create a new schema and assign the schema owner as whatever user you want to use:

CREATE SCHEMA YourSchemaName AUTHORIZATION YourUserName

If there are already objects in the dbo schema that you need to be in YourSchema, you change the schema with:

ALTER SCHEMA YourSchemaName TRANSFER dbo.ObjectNameToTransfer

You can then assign users the default schema of YourSchemaName. You can change the default schema for exsiting users with:

ALTER USER YourUserName WITH DEFAULT_SCHEMA = YourSchemaName

-Sue

|||

Here is the error that I receive when trying to create a new schema for my database:

Msg 15151, Level 16, State 1, Line 1
Cannot find the user 'cqadmin', because it does not exist or you do not have permission.
Msg 2759, Level 16, State 0, Line 1
CREATE SCHEMA failed due to previous errors.

My user, "cqadmin" has public access of the database in question.