Page 4 of 4 FirstFirst ... 234
Results 31 to 40 of 40

Thread: asp newbie

  1. #31
    Join Date
    Apr 2003
    Posts
    13,269
    Rep Power
    34

    Default

    Did you try the link I posted in my last post? It gives instructions on how to change the authentication mode. It's a registry hack. But if you follow the instructions, shouldn't have a problem.
    "The best software is the one that fits your needs." - A_A

    Virus free since: date unknown
    Anti-virus free since: August 2008

  2. #32
    Join Date
    Apr 2003
    Posts
    13,269
    Rep Power
    34

    Default

    Any luck DK?
    "The best software is the one that fits your needs." - A_A

    Virus free since: date unknown
    Anti-virus free since: August 2008

  3. #33
    Join Date
    Jan 2004
    Posts
    2,011
    Rep Power
    0

    Default

    oh yeh sorry for the delayed reply. um yeh i got it to work but it still failed in the long run saying
    Code:
    Cannot open database requested in login ' temp'. Login fails
    from that message i'm guessing i actually got the mixed mode authentifcation because it no longer dismeses the sa account it just wont open the dbase that i created with ems mssql manager.

  4. #34
    Join Date
    Sep 2004
    Posts
    1,905
    Rep Power
    21

    Default

    A related problem :
    How do I install a new user and password to MSDE? (Is this a good idea in general, to add more users?)
    How do I view all users and passwords that are allowed on all databases?
    Last edited by crosswire; Jun 29, 2005 at 07:01 PM.
    Let's act on what we agree on now, and argue later on what we don't.
    Black men leave Barbeque alone if Barbeque don't trouble you

  5. #35
    Join Date
    Sep 2004
    Posts
    1,905
    Rep Power
    21

    Default

    OK I read up on the article provided by AA. Thanks
    http://support.microsoft.com/default...22120121120120

    and I went to Run and type command, then

    osql -?
    for help info

    osql -E -S M3\NetSDK
    to login in trusted connection, then

    sp_password @old = null, @new = 'sapwd', @loginame ='sa'
    go

    to change password, still have to log in as trusted afterwards though so I did log in again and typed

    EXEC sp_helplogins
    go

    Got some usernames, now only to get their passwords

    sp_helplogins
    Let's act on what we agree on now, and argue later on what we don't.
    Black men leave Barbeque alone if Barbeque don't trouble you

  6. #36
    Join Date
    Sep 2004
    Posts
    1,905
    Rep Power
    21

    Default

    OK I think I need to read up the authentication but I think I got it to work, ie logon to a database, I only use the Trusted connection so far and I do not think this is the right method, but anyway


    osql -E -d Northwind -S M3\NetSDK
    using a database name Northwind given from sp_helplogins

    Select * from Customers
    go

    Selecting a table and something happens
    Let's act on what we agree on now, and argue later on what we don't.
    Black men leave Barbeque alone if Barbeque don't trouble you

  7. #37
    Join Date
    Sep 2004
    Posts
    1,905
    Rep Power
    21

    Default

    I did the registry hack and got mine to work with the password

    @DK
    Yours should work too, the proceedure is correct. The problem is that login name that you used is not a member for the database that you want to access.

    I am not good with the password thing yet being new to SQL, unlike you all. There are databases that are accessible by all users, or some users (I wonder if its is by user groups). Users that access a database are given certain permissions in that database. So you need to add that user name to the database.
    Let's act on what we agree on now, and argue later on what we don't.
    Black men leave Barbeque alone if Barbeque don't trouble you

  8. #38
    Join Date
    Sep 2004
    Posts
    1,905
    Rep Power
    21

    Default

    Here is a detailed proceedure I used, for any reference
    The explainations need to be updated as I learn more SQL


    ================================================== =================
    With a fresh boot with HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\NetSDK\MSSQLServer LoginMode=1
    Run
    Code:
    osql -E -S M3\NetSDK
    You are now in admin space if you see "1>", so add new user
    Code:
    EXEC sp_addlogin 'cw', 'cwpsd', 'Northwind', 'us_english'
    go
    Check the users that are present
    Code:
    sp_helplogins
    go
    Now change the registry key above to LoginMode=0
    Restart computer

    Now type
    Code:
    osql -U cw -P cwpsd -S M3\NetSDK -d Northwind
    At the 1> prompt, type your sql statement
    Code:
    select * from customers
    go
    This user, just created, has access to some databases like pubs and Northwind, and some stored proceedures that do not access all databases unlike sa or a trusted connection user.
    To see accessible databases, type sp_helpdb
    Code:
    exit
    Now login as the sa
    Code:
    osql -U sa -P sapwd -S M3\NetSDK
    Type this again to see the login users
    Code:
    sp_helplogins
    Use the sa to change the role of cw to a db_owner in a database.
    Code:
    use Northwind
    go
    sp_adduser 'cw', 'cw', 'db_owner'
    go
    sp_helplogins
    Check the VS.Net Help Collection for the T-SQL references used above
    Code:
    exit
    ================================================== =================
    Let's act on what we agree on now, and argue later on what we don't.
    Black men leave Barbeque alone if Barbeque don't trouble you

  9. #39
    Join Date
    Sep 2004
    Posts
    1,905
    Rep Power
    21

    Default

    Hey DK! have you finished ASP.net

    I found this good article on web services and want to post it but don't know where, so I think I would append it here.

    WebServiceUtil.exe allows us to name a SDL, or contract, as one of the command line arguments and the tool can then generate the source code for a proxy to our Web Service.
    (choose a link)
    http://msdn.microsoft.com/library/en...asp?frame=true
    http://msdn.microsoft.com/library/de...sp02222001.asp
    http://ms-help://MS.VSCC/MS.MSDNVS/d...sp02222001.htm
    Last edited by crosswire; Sep 1, 2005 at 04:28 AM.
    Let's act on what we agree on now, and argue later on what we don't.
    Black men leave Barbeque alone if Barbeque don't trouble you

  10. #40
    Join Date
    Apr 2005
    Posts
    1,333
    Rep Power
    0

    Default

    Quote Originally Posted by death_knight
    first of all asp feels really limited compared to php, less logical as well.
    I don't know about that. I did six weeks rigorous php and i found it pretty inept. eg. on a application with, say, 20 lines of code: "Fatal error on line 85!"

    Don't know if they fixed that 'bug' yet...?
    The fox was probably right - they could have been sour grapes.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •