Cant enter user&password for Integration Services

I'm about to start using Integration Services in Mgmt Studio 2005.

But, when I try to register a server for Integration Services,
the option for choosing between Windows authentication and SQL Server
authentication is greyed out, and it's set to Windows.
My domain user is automatically filled in, but greyed out. I can't enter
my password since this field is also greyed out.
Is this some installation problem? (Connection to a Database Engine works fine.)SSIS doesn't support sql auth (at least not from SSMS). there is only windows auth.

SSAS is the same way.|||My next problem is that I can't make my domain account connect
without making it a member of the server's local Administrators group.

I read this article:

http://msdn2.microsoft.com/en-us/library/aa337083.aspx

which describes how to fix this. I gave my users all kind of rights
for the MsDtsServer component and restarted the Integration Services service on the server, but it doesn't help. What can be missing?|||I had to add my user to the Distributed DCOM Users group, and
the Users group had to get full access to the MsDtsServer component.
Now it works.

Cant enter report manager with forms security

I implemented the sample from microsoft, but i dont know what went wrong i
can access the server but cant enter the report manager, im redirected to
the folder.aspx page but then I get back to UILogon.aspx, could it be that
when i installed RS i ddint check the SSL checkbox, or some other config
problem?Or, perhaps you access the Report Manager by using localhost instead of the
computer name?
--
Hope this helps.
----
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
----
"Rodrigo Sánchez" <rodrigoss@.netshoreprogramming.com> wrote in message
news:OobjdyhkEHA.3556@.TK2MSFTNGP12.phx.gbl...
> I implemented the sample from microsoft, but i dont know what went wrong i
> can access the server but cant enter the report manager, im redirected to
> the folder.aspx page but then I get back to UILogon.aspx, could it be that
> when i installed RS i ddint check the SSL checkbox, or some other config
> problem?
>|||Hi all,
I have been trying ti use the Sample Forms Authentication since morning but
can not make it work still. I followed the steps and could register a user
"administrator" from LOgon.aspx page. I see this user getting created in the
Users table of UserAccounts database. I also add the sample code for username
to RSReportServer.config file as given in the sample description. Now I try
to login using the username and password but brings me back to the Logon.aspx
page. Anybody please help.
PS:- I can also see this user from ReportServer but cannot enter
ReportManager)
Thanks in advance.
Pinal.
"Teo Lachev" wrote:
> Or, perhaps you access the Report Manager by using localhost instead of the
> computer name?
> --
> Hope this helps.
> ----
> Teo Lachev, MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> Publisher website: http://www.manning.com/lachev
> Buy it from Amazon.com: http://shrinkster.com/eq
> Home page and blog: http://www.prologika.com/
> ----
> "Rodrigo Sánchez" <rodrigoss@.netshoreprogramming.com> wrote in message
> news:OobjdyhkEHA.3556@.TK2MSFTNGP12.phx.gbl...
> > I implemented the sample from microsoft, but i dont know what went wrong i
> > can access the server but cant enter the report manager, im redirected to
> > the folder.aspx page but then I get back to UILogon.aspx, could it be that
> > when i installed RS i ddint check the SSL checkbox, or some other config
> > problem?
> >
> >
>
>sql

cant enter data in field

I have a field in my table that is varchar:1500:null, but I cannot enter any more that 994 characters. any ideas why?

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Quotes]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Quotes]
GO

CREATE TABLE [dbo].[Quotes] (
[QuoteID] [int] IDENTITY (1, 1) NOT NULL ,
[DateAdded] [datetime] NULL ,
[CustomerID] [int] NOT NULL ,
[ProductName] [varchar] (100) NULL ,
[RepID] [int] NULL ,
[QuoteNumber] [varchar] (30) NULL ,
[QuoteDate] [datetime] NULL ,
[QuoteTerm] [varchar] (10) NULL ,
[QuoteFOB] [varchar] (15) NULL ,
[QuoteNAIRep] [varchar] (30) NULL ,
[QuoteExpiration] [datetime] NULL ,
[Note] [varchar] (700) NULL ,
[Comment] [varchar] (1500) NULL ,
[OrderRequirement] [varchar] (1000) NULL ,
[Status] [varchar] (1) NULL ,
[DateClosed] [datetime] NULL ,
[ProductType] [varchar] (30) NULL ,
[ImageID] [int] NULL ,
[CloseMonth] [int] NULL ,
[CloseYear] [int] NULL ,
[ClosePercent] [int] NULL ,
[Segment] [varchar] (50) NULL ,
[AccountID] [uniqueidentifier] NULL ,
[ReplacedQuoteID] [int] NULL ,
[Lead] [varchar] (80) NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[Quotes] ADD
CONSTRAINT [DF_Quotes_Closed] DEFAULT ('N') FOR [Status]
GO

CREATE INDEX [idx_RepID] ON [dbo].[Quotes]([RepID]) ON [PRIMARY]
GO

CREATE INDEX [indx_CustomerID] ON [dbo].[Quotes]([CustomerID]) ON [PRIMARY]
GO

CREATE INDEX [indx_QuoteID] ON [dbo].[Quotes]([QuoteID]) ON [PRIMARY]
GO

CREATE INDEX [indx_Status] ON [dbo].[Quotes]([Status]) ON [PRIMARY]
GO

[Comment] [varchar] (1500) NULL , is where I can't enter more than 994 characters.

note - I know very little about SQL, I just had the responsibility placed on me at my job. If this is not enough information to go on to throw an idea at me please let me know what else you need.

Thanks in advanceNo such issue i just ran your script and inserted 1500 characters into the comments column....also when you define 1500 it will give you a capacity of 1500

are you using the insert statement or just entering data through enterprise manager?? cuz insert statement worked fine for me...
insert into quotes (Customerid, comment)
values (3,'Your comment goes here')

Also try to find the length of your largest column by using the following script

select len(comment)
from quotes|||i am entering the text manually. Don't know how to run an insert script.

I ran the sel script and the longest entry is 1000 chars.

would you mind telling me how to run the insert script to apply the comment to quote number 070530JB185438?|||I was able to insert the text I need using the insert script you gave, I just had to add more fields to make it apply to the correct quote...

INSERT INTO Quotes

(QuoteID, CustomerID, QuoteNumber, Comment)

VALUES ('35845', '5695', '070530jb185438', 'comment')

Thanks for the help, it is greatly appreciated.:beer:|||since quoteid is generated automatically you dont need to insert a value there...... according to your table design then customerid is the only non nullable field which needs to be present...

hence for testing purpose if you provide a query as
INSERT INTO Quotes
(CustomerID, Comment)
VALUES ('5695', 'comment')
it would still work...since all other columns are nullable......

Also to test your case you can insert a very long string in place of 'comment'... and inside single quotes of course...

other thing what you can do to test the case is use the update statement
update quotes
set comment = 'You comment goes here'
where customerid = '5695'

this will update the record which has customerid = '5695'
i.e. the record which you have just inserted in the previous post|||Here's a function to insert a 1500 character string of x's into your comment field.

INSERT INTO Quotes
(customerid, comment) VALUES ('1234', REPLACE(SPACE(1500), ' ', 'x'))

then check the length with the Len function

Can't enter data

I keep getting the error message "the value you entered is not consistent
with the data type or length of the column" I verified that I am entering the
correct datatype and length. Any ideas why it is not allowing me to enter
data.
Thanks...Hi,
Can you please post the table structure and the data you are trying to
insert.
Thanks
Hari
MCDBA
"mmc" <mmc@.discussions.microsoft.com> wrote in message
news:8D43843F-621B-4BCD-A855-917F592DB1D5@.microsoft.com...
> I keep getting the error message "the value you entered is not consistent
> with the data type or length of the column" I verified that I am entering
the
> correct datatype and length. Any ideas why it is not allowing me to enter
> data.
> Thanks...

Can't enter data

I keep getting the error message "the value you entered is not consistent
with the data type or length of the column" I verified that I am entering the
correct datatype and length. Any ideas why it is not allowing me to enter
data.
Thanks...
Hi,
Can you please post the table structure and the data you are trying to
insert.
Thanks
Hari
MCDBA
"mmc" <mmc@.discussions.microsoft.com> wrote in message
news:8D43843F-621B-4BCD-A855-917F592DB1D5@.microsoft.com...
> I keep getting the error message "the value you entered is not consistent
> with the data type or length of the column" I verified that I am entering
the
> correct datatype and length. Any ideas why it is not allowing me to enter
> data.
> Thanks...

Can't enter data

I keep getting the error message "the value you entered is not consistent
with the data type or length of the column" I verified that I am entering th
e
correct datatype and length. Any ideas why it is not allowing me to enter
data.
Thanks...Hi,
Can you please post the table structure and the data you are trying to
insert.
Thanks
Hari
MCDBA
"mmc" <mmc@.discussions.microsoft.com> wrote in message
news:8D43843F-621B-4BCD-A855-917F592DB1D5@.microsoft.com...
> I keep getting the error message "the value you entered is not consistent
> with the data type or length of the column" I verified that I am entering
the
> correct datatype and length. Any ideas why it is not allowing me to enter
> data.
> Thanks...

Can't connect to Sql Server 2005

After install Sql Server 2005 as administrator, I enter in the computer as a
limited user. When I start the Management Studio I can't see any data base.
I checked that the service is started and I tried creating a new start
sesion with the name of the limited user in the domain (as I did in sql
server 2000) but it doesn't work.
What else can I do?
Thank you very much."alberto" <alberto@.nospam.es> wrote in message
news:O4JyJ5hSHHA.1036@.TK2MSFTNGP03.phx.gbl...
> After install Sql Server 2005 as administrator, I enter in the computer as
> a limited user. When I start the Management Studio I can't see any data
> base. I checked that the service is started and I tried creating a new
> start sesion with the name of the limited user in the domain (as I did in
> sql server 2000) but it doesn't work.
> What else can I do?
Log into SQL Server as an administrator and create a login for your limited
user, assigning that user either server roles, or database access as
appropriate.
David|||I just did it but I still can't connect. As limited user I don't see any
server.
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> escribió en el
mensaje news:OubC9BiSHHA.3980@.TK2MSFTNGP02.phx.gbl...
>
> "alberto" <alberto@.nospam.es> wrote in message
> news:O4JyJ5hSHHA.1036@.TK2MSFTNGP03.phx.gbl...
>> After install Sql Server 2005 as administrator, I enter in the computer
>> as a limited user. When I start the Management Studio I can't see any
>> data base. I checked that the service is started and I tried creating a
>> new start sesion with the name of the limited user in the domain (as I
>> did in sql server 2000) but it doesn't work.
>> What else can I do?
>
> Log into SQL Server as an administrator and create a login for your
> limited user, assigning that user either server roles, or database access
> as appropriate.
> David|||"alberto" <alberto@.nospam.es> wrote in message
news:#KRbFOiSHHA.5068@.TK2MSFTNGP03.phx.gbl...
>I just did it but I still can't connect. As limited user I don't see any
>server.
>
Can't see it? or can't connect? What are you entering in the "server name"
box in the SQL Server Management Studio connect dialog? What error message
are you getting?
David|||In the combo box of servers I don't see anything.
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> escribió en el
mensaje news:%23r3b$biSHHA.5068@.TK2MSFTNGP03.phx.gbl...
>
> "alberto" <alberto@.nospam.es> wrote in message
> news:#KRbFOiSHHA.5068@.TK2MSFTNGP03.phx.gbl...
>>I just did it but I still can't connect. As limited user I don't see any
>>server.
> Can't see it? or can't connect? What are you entering in the "server
> name" box in the SQL Server Management Studio connect dialog? What error
> message are you getting?
> David|||"alberto" <alberto@.nospam.es> wrote in message
news:##3e2fiSHHA.192@.TK2MSFTNGP04.phx.gbl...
> In the combo box of servers I don't see anything.
>
Then type in the name of the server, or if you are on the same box, type
'(local)'. If you installed a named instance add the instance name.
Default Instance:
MyServer
(local)
Named instance (called MyInstance)
MyServer\MyInstance
(local)\MyInstance
David

Can't connect to Sql Server 2005

After install Sql Server 2005 as administrator, I enter in the computer as a
limited user. When I start the Management Studio I can't see any data base.
I checked that the service is started and I tried creating a new start
sesion with the name of the limited user in the domain (as I did in sql
server 2000) but it doesn't work.
What else can I do?
Thank you very much."alberto" <alberto@.nospam.es> wrote in message
news:O4JyJ5hSHHA.1036@.TK2MSFTNGP03.phx.gbl...
> After install Sql Server 2005 as administrator, I enter in the computer as
> a limited user. When I start the Management Studio I can't see any data
> base. I checked that the service is started and I tried creating a new
> start sesion with the name of the limited user in the domain (as I did in
> sql server 2000) but it doesn't work.
> What else can I do?
Log into SQL Server as an administrator and create a login for your limited
user, assigning that user either server roles, or database access as
appropriate.
David|||I just did it but I still can't connect. As limited user I don't see any
server.
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> escribi en el
mensaje news:OubC9BiSHHA.3980@.TK2MSFTNGP02.phx.gbl...
>
> "alberto" <alberto@.nospam.es> wrote in message
> news:O4JyJ5hSHHA.1036@.TK2MSFTNGP03.phx.gbl...
>
> Log into SQL Server as an administrator and create a login for your
> limited user, assigning that user either server roles, or database access
> as appropriate.
> David|||"alberto" <alberto@.nospam.es> wrote in message
news:#KRbFOiSHHA.5068@.TK2MSFTNGP03.phx.gbl...
>I just did it but I still can't connect. As limited user I don't see any
>server.
>
Can't see it? or can't connect? What are you entering in the "server name"
box in the SQL Server Management Studio connect dialog? What error message
are you getting?
David|||In the combo box of servers I don't see anything.
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> escribi en el
mensaje news:%23r3b$biSHHA.5068@.TK2MSFTNGP03.phx.gbl...
>
> "alberto" <alberto@.nospam.es> wrote in message
> news:#KRbFOiSHHA.5068@.TK2MSFTNGP03.phx.gbl...
> Can't see it? or can't connect? What are you entering in the "server
> name" box in the SQL Server Management Studio connect dialog? What error
> message are you getting?
> David|||"alberto" <alberto@.nospam.es> wrote in message
news:##3e2fiSHHA.192@.TK2MSFTNGP04.phx.gbl...
> In the combo box of servers I don't see anything.
>
Then type in the name of the server, or if you are on the same box, type
'(local)'. If you installed a named instance add the instance name.
Default Instance:
MyServer
(local)
Named instance (called MyInstance)
MyServer\MyInstance
(local)\MyInstance
David