Post reply

sql error

  • September 12, 2007 at 3:32 am

    #118591

    Error try to connect sql2000 A user instance was requsted in the connection string but the server specified not sapport this option Changed the database context to 'master',Changed the language settings to Us-English

    how to solve this

    pls help

    rejithram@gmail.com

  • September 12, 2007 at 8:13 am

    #733119

    Rejith -

    1. Welcome to the forums!

    2. IF this is a SQL 2000 problem, you may have more luck with responses in the SQL 2000 administration forum, rather than 2005.

    3. IF you are serious about getting good advice, you need to give us a good description of the problem. For instance:

    i. Is the user trying to connect directly, or indirectly to the server?

    ii. Is the user a live end-user or a job running in background?

    iii. How is the connection string being built?

    iv. Why did you change the database context to 'master'? What was the context before?

    v. What is the actual string being used?

    vi. What is the actual error message received? describing a message is not the same thing as providing the actual message.

  • September 13, 2007 at 4:58 am

    #733428

    Hai steve,

    Thnks for your replay

    Me first instaled sql server 2005 with vishual c# express edition but some prb occures when i try to insert to the database then i uninstaled the sqlexpress edition and installed the sql 2000 server. then i can stor and retriving information from the database.me do this by giving connection string using udl and write the connection in button click in c#.net .but when i wnt to use datagrid view in my project so i try to connect to database from window like selecting the dasource and then it will not allow me to connect.and it gives tht error.Before it giving another error( An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connection. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

    then i changed the sqlserver in stance from the c# +tools +option+database tool there sqlexpress name is specifed i removed that

    then i got the new error

    if u knw how to resolve this problem pls help me

    thanks

    rejith

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply