| Groups | Blog | Home |
sql server (alternate) : SQL Server 7.0 installation
never setup a server from the beginning, so I am a little new at creating server groups. Alright, I am trying to create a server group. I right click on the "SQL Server Group" and make a name of "TEST" and put in the subgroup of "SQL Server Group". Next, I try to register the "TEST" server group. I right click on the "TEST" server group and New Server Group Registration. (Someone told me I need to know the name of my computer (LAPTOP) and the workgroup name (WORKGROUP) for the next part.) On the following part, for selecting a SQL Server, "LAPTOP" automatically comes up as the available servers, so I add it to the "Added Servers" list. On the next step, I choose the SQL Server authentication and type in the login name as "sa" and the password as "password" (I was told that is the default, but I tried "sa" and "(no password)" and I tried "administrator" and no password.) Then, I add the server group to an "existing SQL Server Group" - group name: "SQL Server Group". Finally, when I try to connect or finish, the following message comes up: "LAPTOP - SQL Server does not exist or access denied, Connection Open". I am not sure what I am doing wrong, I was told that I should setup an ODBC that is SQL Server, but it asks for a database to connect to, and there are none. Please, I hope someone could help me, I am trying to learn SQL Server 7.0 for work. Thanks, in advance, for any help, Grim Reaper
Very few servers will/should have the sa account with either of those two
choices of password. See your SQL Server admin about that. Also maybe the SQL Server you are trying to register is set up fpr NT authentication only in which case you will need tobe allowed access by virtue of your Windows Account. -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org [quoted text, click to view] "Grim Reaper" <73matt@comcast.net> wrote in message news:p_ednTs-9t86R-Dd4p2dnA@comcast.com... > My work let me put SQL Server 7.0 Enterprise Edition on my laptop. I have > never setup a server from the beginning, so I am a little new at creating > server groups. > > Alright, I am trying to create a server group. I right click on the "SQL > Server Group" and make a name of "TEST" and put in the subgroup of "SQL > Server Group". > > Next, I try to register the "TEST" server group. I right click on the "TEST" > server group and New Server Group Registration. (Someone told me I need to > know the name of my computer (LAPTOP) and the workgroup name (WORKGROUP) for > the next part.) On the following part, for selecting a SQL Server, "LAPTOP" > automatically comes up as the available servers, so I add it to the "Added > Servers" list. On the next step, I choose the SQL Server authentication and > type in the login name as "sa" and the password as "password" (I was told > that is the default, but I tried "sa" and "(no password)" and I tried > "administrator" and no password.) Then, I add the server group to an > "existing SQL Server Group" - group name: "SQL Server Group". Finally, when > I try to connect or finish, the following message comes up: "LAPTOP - SQL > Server does not exist or access denied, Connection Open". > > I am not sure what I am doing wrong, I was told that I should setup an ODBC > that is SQL Server, but it asks for a database to connect to, and there are > none. Please, I hope someone could help me, I am trying to learn SQL Server > 7.0 for work. > > Thanks, in advance, for any help, > Grim Reaper > >
The laptop is mine, so I am the "Server Admin". I set up the SQL Server and
I set up Windows XP Professional on my laptop. I have tried the NT authentication, but it did not work, either. So, seeing as though I own the laptop, is there anyway that I can setup the SQL Server on my laptop so that I can use it? If so, how? Thanks, Grim Reaper [quoted text, click to view] "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message news:407e190b$0$31701$fa0fcedb@lovejoy.zen.co.uk... > Very few servers will/should have the sa account with either of those two > choices of password. See your SQL Server admin about that. Also maybe the > SQL Server you are trying to register is set up fpr NT authentication only > in which case you will need tobe allowed access by virtue of your Windows > Account. > > -- > -- > > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) > www.SQLDTS.com - The site for all your DTS needs. > I support PASS - the definitive, global community > for SQL Server professionals - http://www.sqlpass.org > > > "Grim Reaper" <73matt@comcast.net> wrote in message > news:p_ednTs-9t86R-Dd4p2dnA@comcast.com... > > My work let me put SQL Server 7.0 Enterprise Edition on my laptop. I have > > never setup a server from the beginning, so I am a little new at creating > > server groups. > > > > Alright, I am trying to create a server group. I right click on the "SQL > > Server Group" and make a name of "TEST" and put in the subgroup of "SQL > > Server Group". > > > > Next, I try to register the "TEST" server group. I right click on the > "TEST" > > server group and New Server Group Registration. (Someone told me I need to > > know the name of my computer (LAPTOP) and the workgroup name (WORKGROUP) > for > > the next part.) On the following part, for selecting a SQL Server, > "LAPTOP" > > automatically comes up as the available servers, so I add it to the "Added > > Servers" list. On the next step, I choose the SQL Server authentication > and > > type in the login name as "sa" and the password as "password" (I was told > > that is the default, but I tried "sa" and "(no password)" and I tried > > "administrator" and no password.) Then, I add the server group to an > > "existing SQL Server Group" - group name: "SQL Server Group". Finally, > when > > I try to connect or finish, the following message comes up: "LAPTOP - SQL > > Server does not exist or access denied, Connection Open". > > > > I am not sure what I am doing wrong, I was told that I should setup an > ODBC > > that is SQL Server, but it asks for a database to connect to, and there > are > > none. Please, I hope someone could help me, I am trying to learn SQL > Server > > 7.0 for work. > > > > Thanks, in advance, for any help, > > Grim Reaper > > > > > >
[quoted text, click to view]
> If you are a member of the local administrators group on that box then you Actually, the laptop is mine. Therefore, I guess that would make me the> should be able to log in through NT Authentication. administrator. [quoted text, click to view] > What OS are you using on your laptop? I am using Windows XP Professional.[quoted text, click to view] > The service is started right? Not sure what service you mean, here.[quoted text, click to view] > Do you actually have the Client Tools installed or the Engine as well.? I installed everything on the disk for SQL Server 7.0. When everything cameup that it asked me if I wanted to install, I said everything because I was not sure what I needed. Grim Reaper [quoted text, click to view] "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message news:407e6876$0$31673$fa0fcedb@lovejoy.zen.co.uk... > If you are a member of the local administrators group on that box then you > should be able to log in through NT Authentication. > > The service is started right? > > What OS are you using on your laptop? > > Do you actually have the Client Tools installed or the Engine as well.? > > -- > -- > > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) > www.SQLDTS.com - The site for all your DTS needs. > I support PASS - the definitive, global community > for SQL Server professionals - http://www.sqlpass.org > > > "Grim Reaper" <grimrpr@nospam.com> wrote in message > news:sbSdnb6VkMfB-uPdRVn-gw@comcast.com... > > The laptop is mine, so I am the "Server Admin". I set up the SQL Server > and > > I set up Windows XP Professional on my laptop. > > > > I have tried the NT authentication, but it did not work, either. > > > > So, seeing as though I own the laptop, is there anyway that I can setup > the > > SQL Server on my laptop so that I can use it? If so, how? > > > > Thanks, > > Grim Reaper > > > > "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message > > news:407e190b$0$31701$fa0fcedb@lovejoy.zen.co.uk... > > > Very few servers will/should have the sa account with either of those > two > > > choices of password. See your SQL Server admin about that. Also maybe > > the > > > SQL Server you are trying to register is set up fpr NT authentication > > only > > > in which case you will need tobe allowed access by virtue of your > Windows > > > Account. > > > > > > -- > > > -- > > > > > > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) > > > www.SQLDTS.com - The site for all your DTS needs. > > > I support PASS - the definitive, global community > > > for SQL Server professionals - http://www.sqlpass.org > > > > > > > > > "Grim Reaper" <73matt@comcast.net> wrote in message > > > news:p_ednTs-9t86R-Dd4p2dnA@comcast.com... > > > > My work let me put SQL Server 7.0 Enterprise Edition on my laptop. I > > have > > > > never setup a server from the beginning, so I am a little new at > > creating > > > > server groups. > > > > > > > > Alright, I am trying to create a server group. I right click on the > "SQL > > > > Server Group" and make a name of "TEST" and put in the subgroup of > "SQL > > > > Server Group". > > > > > > > > Next, I try to register the "TEST" server group. I right click on the > > > "TEST" > > > > server group and New Server Group Registration. (Someone told me I > need > > to > > > > know the name of my computer (LAPTOP) and the workgroup name > (WORKGROUP) > > > for > > > > the next part.) On the following part, for selecting a SQL Server, > > > "LAPTOP" > > > > automatically comes up as the available servers, so I add it to the > > "Added > > > > Servers" list. On the next step, I choose the SQL Server > authentication > > > and > > > > type in the login name as "sa" and the password as "password" (I was > > told > > > > that is the default, but I tried "sa" and "(no password)" and I tried > > > > "administrator" and no password.) Then, I add the server group to an > > > > "existing SQL Server Group" - group name: "SQL Server Group". Finally, > > > when > > > > I try to connect or finish, the following message comes up: "LAPTOP - > > SQL > > > > Server does not exist or access denied, Connection Open". > > > > > > > > I am not sure what I am doing wrong, I was told that I should setup an > > > ODBC > > > > that is SQL Server, but it asks for a database to connect to, and > there > > > are > > > > none. Please, I hope someone could help me, I am trying to learn SQL > > > Server > > > > 7.0 for work. > > > > > > > > Thanks, in advance, for any help, > > > > Grim Reaper > > > > > > > > > > > > > > > > > > > >
If you are a member of the local administrators group on that box then you
should be able to log in through NT Authentication. The service is started right? What OS are you using on your laptop? Do you actually have the Client Tools installed or the Engine as well.? -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org [quoted text, click to view] "Grim Reaper" <grimrpr@nospam.com> wrote in message news:sbSdnb6VkMfB-uPdRVn-gw@comcast.com... > The laptop is mine, so I am the "Server Admin". I set up the SQL Server and > I set up Windows XP Professional on my laptop. > > I have tried the NT authentication, but it did not work, either. > > So, seeing as though I own the laptop, is there anyway that I can setup the > SQL Server on my laptop so that I can use it? If so, how? > > Thanks, > Grim Reaper > > "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message > news:407e190b$0$31701$fa0fcedb@lovejoy.zen.co.uk... > > Very few servers will/should have the sa account with either of those two > > choices of password. See your SQL Server admin about that. Also maybe > the > > SQL Server you are trying to register is set up fpr NT authentication > only > > in which case you will need tobe allowed access by virtue of your Windows > > Account. > > > > -- > > -- > > > > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) > > www.SQLDTS.com - The site for all your DTS needs. > > I support PASS - the definitive, global community > > for SQL Server professionals - http://www.sqlpass.org > > > > > > "Grim Reaper" <73matt@comcast.net> wrote in message > > news:p_ednTs-9t86R-Dd4p2dnA@comcast.com... > > > My work let me put SQL Server 7.0 Enterprise Edition on my laptop. I > have > > > never setup a server from the beginning, so I am a little new at > creating > > > server groups. > > > > > > Alright, I am trying to create a server group. I right click on the "SQL > > > Server Group" and make a name of "TEST" and put in the subgroup of "SQL > > > Server Group". > > > > > > Next, I try to register the "TEST" server group. I right click on the > > "TEST" > > > server group and New Server Group Registration. (Someone told me I need > to > > > know the name of my computer (LAPTOP) and the workgroup name (WORKGROUP) > > for > > > the next part.) On the following part, for selecting a SQL Server, > > "LAPTOP" > > > automatically comes up as the available servers, so I add it to the > "Added > > > Servers" list. On the next step, I choose the SQL Server authentication > > and > > > type in the login name as "sa" and the password as "password" (I was > told > > > that is the default, but I tried "sa" and "(no password)" and I tried > > > "administrator" and no password.) Then, I add the server group to an > > > "existing SQL Server Group" - group name: "SQL Server Group". Finally, > > when > > > I try to connect or finish, the following message comes up: "LAPTOP - > SQL > > > Server does not exist or access denied, Connection Open". > > > > > > I am not sure what I am doing wrong, I was told that I should setup an > > ODBC > > > that is SQL Server, but it asks for a database to connect to, and there > > are > > > none. Please, I hope someone could help me, I am trying to learn SQL > > Server > > > 7.0 for work. > > > > > > Thanks, in advance, for any help, > > > Grim Reaper > > > > > > > > > > > >
EE will not install the Engine on XP professional. It should have given you
a message about "Client tools only can be installed on this OS" The service should be MSSQLServer -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org [quoted text, click to view] "Grim Reaper" <grimrpr@nospam.com> wrote in message news:39adnQ-FQOs87ePd4p2dnA@comcast.com... > > If you are a member of the local administrators group on that box then you > > should be able to log in through NT Authentication. > Actually, the laptop is mine. Therefore, I guess that would make me the > administrator. > > > What OS are you using on your laptop? > I am using Windows XP Professional. > > > The service is started right? > Not sure what service you mean, here. > > > Do you actually have the Client Tools installed or the Engine as well.? > I installed everything on the disk for SQL Server 7.0. When everything came > up that it asked me if I wanted to install, I said everything because I was > not sure what I needed. > > Grim Reaper > > "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message > news:407e6876$0$31673$fa0fcedb@lovejoy.zen.co.uk... > > If you are a member of the local administrators group on that box then you > > should be able to log in through NT Authentication. > > > > The service is started right? > > > > What OS are you using on your laptop? > > > > Do you actually have the Client Tools installed or the Engine as well.? > > > > -- > > -- > > > > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) > > www.SQLDTS.com - The site for all your DTS needs. > > I support PASS - the definitive, global community > > for SQL Server professionals - http://www.sqlpass.org > > > > > > "Grim Reaper" <grimrpr@nospam.com> wrote in message > > news:sbSdnb6VkMfB-uPdRVn-gw@comcast.com... > > > The laptop is mine, so I am the "Server Admin". I set up the SQL Server > > and > > > I set up Windows XP Professional on my laptop. > > > > > > I have tried the NT authentication, but it did not work, either. > > > > > > So, seeing as though I own the laptop, is there anyway that I can setup > > the > > > SQL Server on my laptop so that I can use it? If so, how? > > > > > > Thanks, > > > Grim Reaper > > > > > > "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message > > > news:407e190b$0$31701$fa0fcedb@lovejoy.zen.co.uk... > > > > Very few servers will/should have the sa account with either of those > > two > > > > choices of password. See your SQL Server admin about that. Also > maybe > > > the > > > > SQL Server you are trying to register is set up fpr NT authentication > > > only > > > > in which case you will need tobe allowed access by virtue of your > > Windows > > > > Account. > > > > > > > > -- > > > > -- > > > > > > > > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) > > > > www.SQLDTS.com - The site for all your DTS needs. > > > > I support PASS - the definitive, global community > > > > for SQL Server professionals - http://www.sqlpass.org > > > > > > > > > > > > "Grim Reaper" <73matt@comcast.net> wrote in message > > > > news:p_ednTs-9t86R-Dd4p2dnA@comcast.com... > > > > > My work let me put SQL Server 7.0 Enterprise Edition on my laptop. I > > > have > > > > > never setup a server from the beginning, so I am a little new at > > > creating > > > > > server groups. > > > > > > > > > > Alright, I am trying to create a server group. I right click on the > > "SQL > > > > > Server Group" and make a name of "TEST" and put in the subgroup of > > "SQL > > > > > Server Group". > > > > > > > > > > Next, I try to register the "TEST" server group. I right click on > the > > > > "TEST" > > > > > server group and New Server Group Registration. (Someone told me I > > need > > > to > > > > > know the name of my computer (LAPTOP) and the workgroup name > > (WORKGROUP) > > > > for > > > > > the next part.) On the following part, for selecting a SQL Server, > > > > "LAPTOP" > > > > > automatically comes up as the available servers, so I add it to the > > > "Added > > > > > Servers" list. On the next step, I choose the SQL Server > > authentication > > > > and > > > > > type in the login name as "sa" and the password as "password" (I was > > > told > > > > > that is the default, but I tried "sa" and "(no password)" and I > tried > > > > > "administrator" and no password.) Then, I add the server group to > an > > > > > "existing SQL Server Group" - group name: "SQL Server Group". > Finally, > > > > when > > > > > I try to connect or finish, the following message comes up: > "LAPTOP - > > > SQL > > > > > Server does not exist or access denied, Connection Open". > > > > > > > > > > I am not sure what I am doing wrong, I was told that I should setup > an > > > > ODBC > > > > > that is SQL Server, but it asks for a database to connect to, and > > there > > > > are > > > > > none. Please, I hope someone could help me, I am trying to learn SQL > > > > Server > > > > > 7.0 for work. > > > > > > > > > > Thanks, in advance, for any help, > > > > > Grim Reaper > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
Is there a way that I can put the 'engine' on my Windows XP? The disk that I
have said that it has Enterprise Edition and Standard Edition. (I hope so :) Grim Reaper [quoted text, click to view] "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message news:407e7bc3$0$31712$fa0fcedb@lovejoy.zen.co.uk... > EE will not install the Engine on XP professional. It should have given you > a message about "Client tools only can be installed on this OS" > The service should be MSSQLServer > > -- > -- > > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) > www.SQLDTS.com - The site for all your DTS needs. > I support PASS - the definitive, global community > for SQL Server professionals - http://www.sqlpass.org > > > "Grim Reaper" <grimrpr@nospam.com> wrote in message > news:39adnQ-FQOs87ePd4p2dnA@comcast.com... > > > If you are a member of the local administrators group on that box then > you > > > should be able to log in through NT Authentication. > > Actually, the laptop is mine. Therefore, I guess that would make me the > > administrator. > > > > > What OS are you using on your laptop? > > I am using Windows XP Professional. > > > > > The service is started right? > > Not sure what service you mean, here. > > > > > Do you actually have the Client Tools installed or the Engine as well.? > > I installed everything on the disk for SQL Server 7.0. When everything > came > > up that it asked me if I wanted to install, I said everything because I > was > > not sure what I needed. > > > > Grim Reaper > > > > "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message > > news:407e6876$0$31673$fa0fcedb@lovejoy.zen.co.uk... > > > If you are a member of the local administrators group on that box then > you > > > should be able to log in through NT Authentication. > > > > > > The service is started right? > > > > > > What OS are you using on your laptop? > > > > > > Do you actually have the Client Tools installed or the Engine as well.? > > > > > > -- > > > -- > > > > > > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) > > > www.SQLDTS.com - The site for all your DTS needs. > > > I support PASS - the definitive, global community > > > for SQL Server professionals - http://www.sqlpass.org > > > > > > > > > "Grim Reaper" <grimrpr@nospam.com> wrote in message > > > news:sbSdnb6VkMfB-uPdRVn-gw@comcast.com... > > > > The laptop is mine, so I am the "Server Admin". I set up the SQL > Server > > > and > > > > I set up Windows XP Professional on my laptop. > > > > > > > > I have tried the NT authentication, but it did not work, either. > > > > > > > > So, seeing as though I own the laptop, is there anyway that I can > setup > > > the > > > > SQL Server on my laptop so that I can use it? If so, how? > > > > > > > > Thanks, > > > > Grim Reaper > > > > > > > > "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message > > > > news:407e190b$0$31701$fa0fcedb@lovejoy.zen.co.uk... > > > > > Very few servers will/should have the sa account with either of > those > > > two > > > > > choices of password. See your SQL Server admin about that. Also > > maybe > > > > the > > > > > SQL Server you are trying to register is set up fpr NT > authentication > > > > only > > > > > in which case you will need tobe allowed access by virtue of your > > > Windows > > > > > Account. > > > > > > > > > > -- > > > > > -- > > > > > > > > > > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) > > > > > www.SQLDTS.com - The site for all your DTS needs. > > > > > I support PASS - the definitive, global community > > > > > for SQL Server professionals - http://www.sqlpass.org > > > > > > > > > > > > > > > "Grim Reaper" <73matt@comcast.net> wrote in message > > > > > news:p_ednTs-9t86R-Dd4p2dnA@comcast.com... > > > > > > My work let me put SQL Server 7.0 Enterprise Edition on my laptop. > I > > > > have > > > > > > never setup a server from the beginning, so I am a little new at > > > > creating > > > > > > server groups. > > > > > > > > > > > > Alright, I am trying to create a server group. I right click on > the > > > "SQL > > > > > > Server Group" and make a name of "TEST" and put in the subgroup of > > > "SQL > > > > > > Server Group". > > > > > > > > > > > > Next, I try to register the "TEST" server group. I right click on > > the > > > > > "TEST" > > > > > > server group and New Server Group Registration. (Someone told me I > > > need > > > > to > > > > > > know the name of my computer (LAPTOP) and the workgroup name > > > (WORKGROUP) > > > > > for > > > > > > the next part.) On the following part, for selecting a SQL > Server, > > > > > "LAPTOP" > > > > > > automatically comes up as the available servers, so I add it to > the > > > > "Added > > > > > > Servers" list. On the next step, I choose the SQL Server > > > authentication > > > > > and > > > > > > type in the login name as "sa" and the password as "password" (I > was > > > > told > > > > > > that is the default, but I tried "sa" and "(no password)" and I > > tried > > > > > > "administrator" and no password.) Then, I add the server group to > > an > > > > > > "existing SQL Server Group" - group name: "SQL Server Group". > > Finally, > > > > > when > > > > > > I try to connect or finish, the following message comes up: > > "LAPTOP - > > > > SQL > > > > > > Server does not exist or access denied, Connection Open". > > > > > > > > > > > > I am not sure what I am doing wrong, I was told that I should > setup > > an > > > > > ODBC > > > > > > that is SQL Server, but it asks for a database to connect to, and > > > there > > > > > are > > > > > > none. Please, I hope someone could help me, I am trying to learn > SQL > > > > > Server > > > > > > 7.0 for work. > > > > > > > > > > > > Thanks, in advance, for any help, > > > > > > Grim Reaper > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
Not on XP using the versions of SQL Server you mention.
Developer Edition, Personal Edition yes. Have a look in BOL here mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\arc hitec.chm::/8_ar_ts_7eur.htm -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org [quoted text, click to view] "Grim Reaper" <grimrpr@nospam.com> wrote in message news:6M-dnb31TL6ZseLdRVn-jA@comcast.com... > Is there a way that I can put the 'engine' on my Windows XP? The disk that I > have said that it has Enterprise Edition and Standard Edition. (I hope so :) > > Grim Reaper > > "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message > news:407e7bc3$0$31712$fa0fcedb@lovejoy.zen.co.uk... > > EE will not install the Engine on XP professional. It should have given > you > > a message about "Client tools only can be installed on this OS" > > The service should be MSSQLServer > > > > -- > > -- > > > > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) > > www.SQLDTS.com - The site for all your DTS needs. > > I support PASS - the definitive, global community > > for SQL Server professionals - http://www.sqlpass.org > > > > > > "Grim Reaper" <grimrpr@nospam.com> wrote in message > > news:39adnQ-FQOs87ePd4p2dnA@comcast.com... > > > > If you are a member of the local administrators group on that box then > > you > > > > should be able to log in through NT Authentication. > > > Actually, the laptop is mine. Therefore, I guess that would make me the > > > administrator. > > > > > > > What OS are you using on your laptop? > > > I am using Windows XP Professional. > > > > > > > The service is started right? > > > Not sure what service you mean, here. > > > > > > > Do you actually have the Client Tools installed or the Engine as > well.? > > > I installed everything on the disk for SQL Server 7.0. When everything > > came > > > up that it asked me if I wanted to install, I said everything because I > > was > > > not sure what I needed. > > > > > > Grim Reaper > > > > > > "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message > > > news:407e6876$0$31673$fa0fcedb@lovejoy.zen.co.uk... > > > > If you are a member of the local administrators group on that box then > > you > > > > should be able to log in through NT Authentication. > > > > > > > > The service is started right? > > > > > > > > What OS are you using on your laptop? > > > > > > > > Do you actually have the Client Tools installed or the Engine as > well.? > > > > > > > > -- > > > > -- > > > > > > > > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) > > > > www.SQLDTS.com - The site for all your DTS needs. > > > > I support PASS - the definitive, global community > > > > for SQL Server professionals - http://www.sqlpass.org > > > > > > > > > > > > "Grim Reaper" <grimrpr@nospam.com> wrote in message > > > > news:sbSdnb6VkMfB-uPdRVn-gw@comcast.com... > > > > > The laptop is mine, so I am the "Server Admin". I set up the SQL > > Server > > > > and > > > > > I set up Windows XP Professional on my laptop. > > > > > > > > > > I have tried the NT authentication, but it did not work, either. > > > > > > > > > > So, seeing as though I own the laptop, is there anyway that I can > > setup > > > > the > > > > > SQL Server on my laptop so that I can use it? If so, how? > > > > > > > > > > Thanks, > > > > > Grim Reaper > > > > > > > > > > "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message > > > > > news:407e190b$0$31701$fa0fcedb@lovejoy.zen.co.uk... > > > > > > Very few servers will/should have the sa account with either of > > those > > > > two > > > > > > choices of password. See your SQL Server admin about that. Also > > > maybe > > > > > the > > > > > > SQL Server you are trying to register is set up fpr NT > > authentication > > > > > only > > > > > > in which case you will need tobe allowed access by virtue of your > > > > Windows > > > > > > Account. > > > > > > > > > > > > -- > > > > > > -- > > > > > > > > > > > > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) > > > > > > www.SQLDTS.com - The site for all your DTS needs. > > > > > > I support PASS - the definitive, global community > > > > > > for SQL Server professionals - http://www.sqlpass.org > > > > > > > > > > > > > > > > > > "Grim Reaper" <73matt@comcast.net> wrote in message > > > > > > news:p_ednTs-9t86R-Dd4p2dnA@comcast.com... > > > > > > > My work let me put SQL Server 7.0 Enterprise Edition on my > laptop. > > I > > > > > have > > > > > > > never setup a server from the beginning, so I am a little new at > > > > > creating > > > > > > > server groups. > > > > > > > > > > > > > > Alright, I am trying to create a server group. I right click on > > the > > > > "SQL > > > > > > > Server Group" and make a name of "TEST" and put in the subgroup > of > > > > "SQL > > > > > > > Server Group". > > > > > > > > > > > > > > Next, I try to register the "TEST" server group. I right click > on > > > the > > > > > > "TEST" > > > > > > > server group and New Server Group Registration. (Someone told me > I > > > > need > > > > > to > > > > > > > know the name of my computer (LAPTOP) and the workgroup name > > > > (WORKGROUP) > > > > > > for > > > > > > > the next part.) On the following part, for selecting a SQL > > Server, > > > > > > "LAPTOP" > > > > > > > automatically comes up as the available servers, so I add it to > > the > > > > > "Added > > > > > > > Servers" list. On the next step, I choose the SQL Server > > > > authentication > > > > > > and > > > > > > > type in the login name as "sa" and the password as "password" (I > > was > > > > > told > > > > > > > that is the default, but I tried "sa" and "(no password)" and I > > > tried > > > > > > > "administrator" and no password.) Then, I add the server group > to > > > an > > > > > > > "existing SQL Server Group" - group name: "SQL Server Group". > > > Finally, > > > > > > when > > > > > > > I try to connect or finish, the following message comes up: > > > "LAPTOP - > > > > > SQL > > > > > > > Server does not exist or access denied, Connection Open". > > > > > > > > > > > > > > I am not sure what I am doing wrong, I was told that I should > > setup > > > an > > > > > > ODBC > > > > > > > that is SQL Server, but it asks for a database to connect to, > and > > > > there > > > > > > are > > > > > > > none. Please, I hope someone could help me, I am trying to learn > > SQL > > > > > > Server > > > > > > > 7.0 for work. > > > > > > > > > > > > > > Thanks, in advance, for any help, > > > > > > > Grim Reaper > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
Don't see what you're looking for? Try a search.
|
January 2003
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
| home · blog · groups | Questions? Comments? Contact the dn |