Click here to Skip to main content
15,921,351 members
Home / Discussions / Database
   

Database

 
GeneralRe: AutoNumber field limit Pin
Terry Denham13-Jan-03 10:56
Terry Denham13-Jan-03 10:56 
GeneralHelp error "Login failed for user 'PRESARIO1692\ASPNET'. " Pin
marnicola9-Jan-03 11:54
marnicola9-Jan-03 11:54 
GeneralRe: Help error "Login failed for user 'PRESARIO1692\ASPNET'. " Pin
Mazdak9-Jan-03 19:18
Mazdak9-Jan-03 19:18 
GeneralRe: Help error "Login failed for user 'PRESARIO1692\ASPNET'. " Pin
marnicola10-Jan-03 3:30
marnicola10-Jan-03 3:30 
GeneralRe: Help error "Login failed for user 'PRESARIO1692\ASPNET'. " Pin
Mazdak10-Jan-03 3:54
Mazdak10-Jan-03 3:54 
GeneralRe: Help error "Login failed for user 'PRESARIO1692\ASPNET'. " Pin
marnicola10-Jan-03 6:46
marnicola10-Jan-03 6:46 
GeneralRe: Help error "Login failed for user 'PRESARIO1692\ASPNET'. " Pin
Mazdak10-Jan-03 7:18
Mazdak10-Jan-03 7:18 
GeneralRe: Help error "Login failed for user 'PRESARIO1692\ASPNET'. " Pin
marnicola10-Jan-03 8:39
marnicola10-Jan-03 8:39 
Well now i have try to run a scrip i have fount on the CD
that before i haven't done because i didn't know how to run scripts this is the result :

C:\Programmi\Microsoft SQL Server>osql -E sa -i installcontacts.sql
1> 2> 3> 4> Msg 3702, Level 16, State 4, Server PRESARIO1692, Line 3
Cannot drop the database 'Contacts' because it is currently in use.
1> 2> 3> 4> Msg 1801, Level 16, State 3, Server PRESARIO1692, Line 2
Database 'Contacts' already exists.
1> 2> 3> 1> 2> 3> 1> 2> 3> 1> 2> 3> 1> 2> 3> 1> 2> 3> 1> 2> 3> 1> 2> 3> 1> 2> 3>
1> 2> 3> 1> 2> 3> 1> 2> 3> 1> 2> 3> 1> 2> 3> 1> 2> 3> 1> 2> 3> 1> 2> 3> 1> 2> 3
> 1> 2> 3> 1> 2> 3> 4> 5> 1> 2> 3> 4> 5> 1> 2> 3> 4> 5> 1> 2> 3> 4> 5> 1> 2> 3>
4> 5> 'ASPNET' added to role 'db_accessadmin'.
1> 2> 3> 4> 'ASPNET' added to role 'db_backupoperator'.
1> 2> 3> 4> 'ASPNET' added to role 'db_datareader'.
1> 2> 3> 4> 'ASPNET' added to role 'db_datawriter'.
1> 2> 3> 4> 'ASPNET' added to role 'db_ddladmin'.
1> 2> 3> 4> 'ASPNET' added to role 'db_denydatareader'.
1> 2> 3> 4> 'ASPNET' added to role 'db_denydatawriter'.
1> 2> 3> 4> 'ASPNET' added to role 'db_owner'.
1> 2> 3> 4> 'ASPNET' added to role 'db_securityadmin'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 1> 2> 3> 4> 5> 6> 7> 1> 2> 3> 4> 5> 6> 7> 8>
9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 2
9> 1> 2> 3> 4> 5> 6> 7> 1> 2> 3> 4> 5> 6> 7> 1> 2> 3> 4> 5> 6> 7> 1> 2> 3> 1> 2>
3> 1> 2> 3> 1> 2> 3> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17>
18> 19> 20> 21> 22> 23> 24> 25> Msg 170, Level 15, State 1, Server PRESARIO1692
, Line 15
Line 15: Incorrect syntax near 'Contact Types'.

It seems the Contacts db(my db) was already added to the master.mdf infact master in the beginning was 1 M now it's about 12M. I think Visual Studio did.
Plus the script added ASPNET user as reader writer and so on.
But still i have the same error , after the compilation was okay . I get the error when the browser open and contact both servers.

I don't know
GeneralRe: Help error "Login failed for user 'PRESARIO1692\ASPNET'. " Pin
marnicola10-Jan-03 9:08
marnicola10-Jan-03 9:08 
GeneralRe: Help error "Login failed for user 'PRESARIO1692\ASPNET'. " Pin
marnicola10-Jan-03 9:17
marnicola10-Jan-03 9:17 
GeneralRe: Help error "Login failed for user 'PRESARIO1692\ASPNET'. " Pin
marnicola10-Jan-03 9:15
marnicola10-Jan-03 9:15 
GeneralRe: Help error "Login failed for user 'PRESARIO1692\ASPNET'. " Pin
marnicola10-Jan-03 10:53
marnicola10-Jan-03 10:53 
GeneralRe: Help error "Login failed for user 'PRESARIO1692\ASPNET'. " Pin
leppie10-Jan-03 6:28
leppie10-Jan-03 6:28 
GeneralRe: Help error "Login failed for user 'PRESARIO1692\ASPNET'. " Pin
marnicola10-Jan-03 6:42
marnicola10-Jan-03 6:42 
GeneralRe: Help error "Login failed for user 'PRESARIO1692\ASPNET'. " Pin
leppie10-Jan-03 7:05
leppie10-Jan-03 7:05 
GeneralArray Question Pin
Robby7-Jan-03 3:24
Robby7-Jan-03 3:24 
GeneralGetting 'Invalid RESX input' Pin
garfild6-Jan-03 22:21
garfild6-Jan-03 22:21 
GeneralRe: Getting 'Invalid RESX input' Pin
leppie7-Jan-03 6:14
leppie7-Jan-03 6:14 
GeneralADO at Startup Pin
fordge6-Jan-03 21:17
fordge6-Jan-03 21:17 
GeneralRe: ADO at Startup Pin
perlmunger7-Jan-03 5:50
perlmunger7-Jan-03 5:50 
GeneralRe: ADO at Startup Pin
fordge7-Jan-03 12:42
fordge7-Jan-03 12:42 
GeneralRe: ADO at Startup Pin
fordge22-Jan-03 15:22
fordge22-Jan-03 15:22 
GeneralDistinct Row Problem Pin
perlmunger6-Jan-03 13:28
perlmunger6-Jan-03 13:28 
GeneralRe: Distinct Row Problem Pin
l a u r e n6-Jan-03 13:35
l a u r e n6-Jan-03 13:35 
GeneralRe: Distinct Row Problem Pin
perlmunger6-Jan-03 13:46
perlmunger6-Jan-03 13:46 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.