A bad error!

hi friends!
i have a web service in .NET 2003 that contain below error and I cant handle it...
...

Anunhandled exception of type 'System.Web.Services.Protocols.SoapException'occurred in system.web.services.dll

Additionalinformation: System.Web.Services.Protocols.SoapException: Server was unable toprocess request. --> System.Data.SqlClient.SqlException: Login failed foruser 'MICROGOD3\ASPNET'.

atSystem.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception,Boolean breakConnection)

atSystem.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObjectstateObj)

at System.Data.SqlClient.TdsParser.Run(RunBehaviorrunBehavior, SqlCommand cmdHandler, SqlDataReader dataStream,BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

atSystem.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)

atSystem.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnectionowningObject, SqlConnectionString connectionOptions, String newPassword,Boolean redirectedUserInstance)

atSystem.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentityidentity, SqlConnectionString connectionOptions, Object providerInfo, StringnewPassword, SqlConnection owningObject, Boolean redirectedUserInstance)

atSystem.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptionsoptions, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnectionowning Connection)

atSystem.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionowning Connection, DbConnectionPool pool, DbConnectionOptions options)

atSystem.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnectionowningObject)

atSystem.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnectionowningObject)

atSystem.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnectionowningObject)

atSystem.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)

atSystem.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnectionouterConnection, DbConnectionFactory connectionFactory)

at System.Data.SqlClient.SqlConnection.Open()

atSystem.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[]datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommandcommand, CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.Fill(DataSetdataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommandcommand, CommandBehavior behavior)

atSystem.Data.Common.DbDataAdapter.Fill(DataSet dataSet)

at LeitnerWebService.Service1.GetData() inc:\inetpub\wwwroot\leitnerwebservice\service1.asmx.cs:line 68

-- End of inner exception stack trace --

PLEASE HELP ME!The Windows user, the web service runs under on the server, user being MICROGOD3\ASPNET based on the error message, does not have permissions to log into the SQL Server you use. It should have a login in SQL Server and the login should be granted permissions to access the database in question.

64 bit database

Does INTEGER type take 8 bytes (64 bits) or 4 bytes (32 bits) of the
disk space?
MHSmallint = 2 bytes
Integer = 4 bytes
Bigint = 8 bytes
--
Ekrem Önsoy
"Marius Horak" <nobody@.eu.con> wrote in message
news:OBgwZ0e9HHA.3916@.TK2MSFTNGP02.phx.gbl...
> Does INTEGER type take 8 bytes (64 bits) or 4 bytes (32 bits) of the
> disk space?
> MH|||... and it is the same for 32 and 64 bit. In fact, the database format is exactly the same across
32/64 bit.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
news:095B7B19-6006-4BFD-A0A3-D0576725BA66@.microsoft.com...
> Smallint = 2 bytes
> Integer = 4 bytes
> Bigint = 8 bytes
> --
> Ekrem Önsoy
>
> "Marius Horak" <nobody@.eu.con> wrote in message news:OBgwZ0e9HHA.3916@.TK2MSFTNGP02.phx.gbl...
>> Does INTEGER type take 8 bytes (64 bits) or 4 bytes (32 bits) of the
>> disk space?
>> MH
>

6.5 SQL - Help! - Change column type?

Please Help!
I have a column of type CHAR(255). However, a situation has arose in which
it needs to be larger. I would like to able to change the type to TEXT, but
I can't find any way to do this. What can I do?
Thanks for any help.In SQl 6.5 there is no option ALTER COLUMN in ALTER TABLE statement. Only
way is
1. Export the data out (BCP OUT)
2. Script the table structure including indexes and constraints
3. Drop the table
4. Create the table , change the CHAR(255) data type to Text data type
5. Import the data back (Use BCP IN)
Note:
If it is production, pls do a trail run in test server before doing.
Thanks
Hari
MCDBA
"William" <maxc@.provide.net@.provide.net> wrote in message
news:u3iuyIoEEHA.2076@.TK2MSFTNGP09.phx.gbl...
> Please Help!
> I have a column of type CHAR(255). However, a situation has arose in which
> it needs to be larger. I would like to able to change the type to TEXT,
but
> I can't find any way to do this. What can I do?
> Thanks for any help.
>|||You need to re-create the table. Pre-7 didn't support changing column attrib
utes.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"William" <maxc@.provide.net@.provide.net> wrote in message news:u3iuyIoEEHA.2076@.TK2MSFTNGP0
9.phx.gbl...
> Please Help!
> I have a column of type CHAR(255). However, a situation has arose in which
> it needs to be larger. I would like to able to change the type to TEXT, bu
t
> I can't find any way to do this. What can I do?
> Thanks for any help.
>