|
|
You're in the
sql server new users
group:(local) problem
sql server new users:
SQL Server instance on the server. By default the 1st instance is the "Default" instance and takes on the name of the server. Any additional instances must be "Named" Instances which are referenced by using the server name and the instance name. (Local) only applies to a default instance. The bottom line is that you need a way to tell one instance from another and that is what the named instances do. Have a look in BOL for more details but here are some links specific to Express that may be helpful: http://msdn2.microsoft.com/en-us/library/ms345154.aspx Express Overview http://msdn2.microsoft.com/en-us/library/ms165672.aspx Comparing Express with MSDE http://msdn2.microsoft.com/en-us/library/bb264564.aspx User Instances http://betav.com/blog/billva/2006/06/getting_and_staying_connected.html Getting & Staying Connected http://msdn2.microsoft.com/en-us/library/ms345318.aspx Tutorial on connecting http://www.datamasker.com/SSE2005_NetworkCfg.htm Configuring Express for Remote Access https://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx Configuring Remote Access http://www.kbalertz.com/Feedback_914277.aspx Configuring SQL2005 for remote access http://msdn2.microsoft.com/en-us/library/bb264562.aspx Embedding Express in Apps http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796&DisplayLang=en SSMS Express http://blogs.msdn.com/rogerwolterblog/archive/2006/04/13/575974.aspx Backing up Express -- Andrew J. Kelly SQL MVP Solid Quality Mentors [quoted text, click to view] "Andrew Kennard" <b@a.com> wrote in message
news:uyHegRfBIHA.5328@TK2MSFTNGP05.phx.gbl... > Hi All > > I have one machine that has the SQL Dev edition on and another that uses > SQL Express > > On the SQL Dev machine using a server name of (local) works fine > > On the machine that uses SQL Express this does not work and I have to use > COMPUTERNAME\SQLEXPRESS > > Any idea on why this might be ? > > Can SQL express be connected to using (local) ? > > Thanks in advance > > Andrew > >
Hi All
I have one machine that has the SQL Dev edition on and another that uses SQL Express On the SQL Dev machine using a server name of (local) works fine On the machine that uses SQL Express this does not work and I have to use COMPUTERNAME\SQLEXPRESS Any idea on why this might be ? Can SQL express be connected to using (local) ? Thanks in advance Andrew
Andrew
Thanks for your reply. Sorry I should have been clearer both these machines are stand alone and not connected to a server When Express is installed it sounds like it matters wether the "enable user instances" is checked ? Thanks Andrew [quoted text, click to view] "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message news:eOWQ2JgBIHA.1356@TK2MSFTNGP03.phx.gbl... > It has nothing to do with Express really it is the fact you have more than > 1 SQL Server instance on the server. By default the 1st instance is the > "Default" instance and takes on the name of the server. Any additional > instances must be "Named" Instances which are referenced by using the > server name and the instance name. (Local) only applies to a default > instance. The bottom line is that you need a way to tell one instance from > another and that is what the named instances do. Have a look in BOL for > more details but here are some links specific to Express that may be > helpful: > > http://msdn2.microsoft.com/en-us/library/ms345154.aspx Express Overview > http://msdn2.microsoft.com/en-us/library/ms165672.aspx Comparing Express > with MSDE > http://msdn2.microsoft.com/en-us/library/bb264564.aspx User Instances > http://betav.com/blog/billva/2006/06/getting_and_staying_connected.html > Getting & Staying Connected > http://msdn2.microsoft.com/en-us/library/ms345318.aspx Tutorial on > connecting > http://www.datamasker.com/SSE2005_NetworkCfg.htm Configuring Express > for Remote Access > https://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx > Configuring Remote Access > http://www.kbalertz.com/Feedback_914277.aspx Configuring SQL2005 for > remote access > http://msdn2.microsoft.com/en-us/library/bb264562.aspx Embedding Express > in Apps > http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796&DisplayLang=en > SSMS Express > http://blogs.msdn.com/rogerwolterblog/archive/2006/04/13/575974.aspx > Backing up Express > > -- > Andrew J. Kelly SQL MVP > Solid Quality Mentors > > > "Andrew Kennard" <b@a.com> wrote in message > news:uyHegRfBIHA.5328@TK2MSFTNGP05.phx.gbl... >> Hi All >> >> I have one machine that has the SQL Dev edition on and another that uses >> SQL Express >> >> On the SQL Dev machine using a server name of (local) works fine >> >> On the machine that uses SQL Express this does not work and I have to use >> COMPUTERNAME\SQLEXPRESS >> >> Any idea on why this might be ? >> >> Can SQL express be connected to using (local) ? >> >> Thanks in advance >> >> Andrew >> >> >
Just de installed and reinstalled express without the user instances box
checked but no difference ? Thanks Andrew [quoted text, click to view] "Andrew Kennard" <b@a.com> wrote in message news:uLRFNSlBIHA.3916@TK2MSFTNGP02.phx.gbl... > Andrew > > Thanks for your reply. > > Sorry I should have been clearer both these machines are stand alone and > not connected to a server > > When Express is installed it sounds like it matters wether the "enable > user instances" is checked ? > > Thanks > > Andrew > > > > "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message > news:eOWQ2JgBIHA.1356@TK2MSFTNGP03.phx.gbl... >> It has nothing to do with Express really it is the fact you have more >> than 1 SQL Server instance on the server. By default the 1st instance is >> the "Default" instance and takes on the name of the server. Any >> additional instances must be "Named" Instances which are referenced by >> using the server name and the instance name. (Local) only applies to a >> default instance. The bottom line is that you need a way to tell one >> instance from another and that is what the named instances do. Have a >> look in BOL for more details but here are some links specific to Express >> that may be helpful: >> >> http://msdn2.microsoft.com/en-us/library/ms345154.aspx Express Overview >> http://msdn2.microsoft.com/en-us/library/ms165672.aspx Comparing Express >> with MSDE >> http://msdn2.microsoft.com/en-us/library/bb264564.aspx User Instances >> http://betav.com/blog/billva/2006/06/getting_and_staying_connected.html >> Getting & Staying Connected >> http://msdn2.microsoft.com/en-us/library/ms345318.aspx Tutorial on >> connecting >> http://www.datamasker.com/SSE2005_NetworkCfg.htm Configuring >> Express for Remote Access >> https://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx >> Configuring Remote Access >> http://www.kbalertz.com/Feedback_914277.aspx Configuring SQL2005 for >> remote access >> http://msdn2.microsoft.com/en-us/library/bb264562.aspx Embedding Express >> in Apps >> http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796&DisplayLang=en >> SSMS Express >> http://blogs.msdn.com/rogerwolterblog/archive/2006/04/13/575974.aspx >> Backing up Express >> >> -- >> Andrew J. Kelly SQL MVP >> Solid Quality Mentors >> >> >> "Andrew Kennard" <b@a.com> wrote in message >> news:uyHegRfBIHA.5328@TK2MSFTNGP05.phx.gbl... >>> Hi All >>> >>> I have one machine that has the SQL Dev edition on and another that uses >>> SQL Express >>> >>> On the SQL Dev machine using a server name of (local) works fine >>> >>> On the machine that uses SQL Express this does not work and I have to >>> use COMPUTERNAME\SQLEXPRESS >>> >>> Any idea on why this might be ? >>> >>> Can SQL express be connected to using (local) ? >>> >>> Thanks in advance >>> >>> Andrew >>> >>> >> > >
Found it ! Reinstalled again and checked box that hides advanced options
The then gives you a wizard page to install the default instance which means (loacl) now works Thanks [quoted text, click to view] "Andrew Kennard" <b@a.com> wrote in message news:eFKIgglBIHA.5868@TK2MSFTNGP05.phx.gbl... > Just de installed and reinstalled express without the user instances box > checked but no difference ? > > Thanks > > Andrew > > "Andrew Kennard" <b@a.com> wrote in message > news:uLRFNSlBIHA.3916@TK2MSFTNGP02.phx.gbl... >> Andrew >> >> Thanks for your reply. >> >> Sorry I should have been clearer both these machines are stand alone and >> not connected to a server >> >> When Express is installed it sounds like it matters wether the "enable >> user instances" is checked ? >> >> Thanks >> >> Andrew >> >> >> >> "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message >> news:eOWQ2JgBIHA.1356@TK2MSFTNGP03.phx.gbl... >>> It has nothing to do with Express really it is the fact you have more >>> than 1 SQL Server instance on the server. By default the 1st instance is >>> the "Default" instance and takes on the name of the server. Any >>> additional instances must be "Named" Instances which are referenced by >>> using the server name and the instance name. (Local) only applies to a >>> default instance. The bottom line is that you need a way to tell one >>> instance from another and that is what the named instances do. Have a >>> look in BOL for more details but here are some links specific to Express >>> that may be helpful: >>> >>> http://msdn2.microsoft.com/en-us/library/ms345154.aspx Express Overview >>> http://msdn2.microsoft.com/en-us/library/ms165672.aspx Comparing >>> Express with MSDE >>> http://msdn2.microsoft.com/en-us/library/bb264564.aspx User Instances >>> http://betav.com/blog/billva/2006/06/getting_and_staying_connected.html >>> Getting & Staying Connected >>> http://msdn2.microsoft.com/en-us/library/ms345318.aspx Tutorial on >>> connecting >>> http://www.datamasker.com/SSE2005_NetworkCfg.htm Configuring >>> Express for Remote Access >>> https://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx >>> Configuring Remote Access >>> http://www.kbalertz.com/Feedback_914277.aspx Configuring SQL2005 for >>> remote access >>> http://msdn2.microsoft.com/en-us/library/bb264562.aspx Embedding >>> Express in Apps >>> http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796&DisplayLang=en >>> SSMS Express >>> http://blogs.msdn.com/rogerwolterblog/archive/2006/04/13/575974.aspx >>> Backing up Express >>> >>> -- >>> Andrew J. Kelly SQL MVP >>> Solid Quality Mentors >>> >>> >>> "Andrew Kennard" <b@a.com> wrote in message >>> news:uyHegRfBIHA.5328@TK2MSFTNGP05.phx.gbl... >>>> Hi All >>>> >>>> I have one machine that has the SQL Dev edition on and another that >>>> uses SQL Express >>>> >>>> On the SQL Dev machine using a server name of (local) works fine >>>> >>>> On the machine that uses SQL Express this does not work and I have to >>>> use COMPUTERNAME\SQLEXPRESS >>>> >>>> Any idea on why this might be ? >>>> >>>> Can SQL express be connected to using (local) ? >>>> >>>> Thanks in advance >>>> >>>> Andrew >>>> >>>> >>> >> >> > >
By server I meant the machine the SQL Instances are running on. To SQL
Server that is the server. -- Andrew J. Kelly SQL MVP Solid Quality Mentors [quoted text, click to view] "Andrew Kennard" <b@a.com> wrote in message
news:uLRFNSlBIHA.3916@TK2MSFTNGP02.phx.gbl... > Andrew > > Thanks for your reply. > > Sorry I should have been clearer both these machines are stand alone and > not connected to a server > > When Express is installed it sounds like it matters wether the "enable > user instances" is checked ? > > Thanks > > Andrew > > > > "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message > news:eOWQ2JgBIHA.1356@TK2MSFTNGP03.phx.gbl... >> It has nothing to do with Express really it is the fact you have more >> than 1 SQL Server instance on the server. By default the 1st instance is >> the "Default" instance and takes on the name of the server. Any >> additional instances must be "Named" Instances which are referenced by >> using the server name and the instance name. (Local) only applies to a >> default instance. The bottom line is that you need a way to tell one >> instance from another and that is what the named instances do. Have a >> look in BOL for more details but here are some links specific to Express >> that may be helpful: >> >> http://msdn2.microsoft.com/en-us/library/ms345154.aspx Express Overview >> http://msdn2.microsoft.com/en-us/library/ms165672.aspx Comparing Express >> with MSDE >> http://msdn2.microsoft.com/en-us/library/bb264564.aspx User Instances >> http://betav.com/blog/billva/2006/06/getting_and_staying_connected.html >> Getting & Staying Connected >> http://msdn2.microsoft.com/en-us/library/ms345318.aspx Tutorial on >> connecting >> http://www.datamasker.com/SSE2005_NetworkCfg.htm Configuring >> Express for Remote Access >> https://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx >> Configuring Remote Access >> http://www.kbalertz.com/Feedback_914277.aspx Configuring SQL2005 for >> remote access >> http://msdn2.microsoft.com/en-us/library/bb264562.aspx Embedding Express >> in Apps >> http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796&DisplayLang=en >> SSMS Express >> http://blogs.msdn.com/rogerwolterblog/archive/2006/04/13/575974.aspx >> Backing up Express >> >> -- >> Andrew J. Kelly SQL MVP >> Solid Quality Mentors >> >> >> "Andrew Kennard" <b@a.com> wrote in message >> news:uyHegRfBIHA.5328@TK2MSFTNGP05.phx.gbl... >>> Hi All >>> >>> I have one machine that has the SQL Dev edition on and another that uses >>> SQL Express >>> >>> On the SQL Dev machine using a server name of (local) works fine >>> >>> On the machine that uses SQL Express this does not work and I have to >>> use COMPUTERNAME\SQLEXPRESS >>> >>> Any idea on why this might be ? >>> >>> Can SQL express be connected to using (local) ? >>> >>> Thanks in advance >>> >>> Andrew >>> >>> >> > >
What you have done is removed all the instances (two in your case) and
reinstalled just the Express and made it the default instance. That will allow you to use LOCAL but why is that so important? You really should get in the habit of using the instance name or just the machine name if it is the default instance. That way you treat them all the same more of less. -- Andrew J. Kelly SQL MVP Solid Quality Mentors [quoted text, click to view] "Andrew Kennard" <b@a.com> wrote in message
news:u4LYfulBIHA.5752@TK2MSFTNGP02.phx.gbl... > Found it ! Reinstalled again and checked box that hides advanced options > > The then gives you a wizard page to install the default instance which > means (loacl) now works > > Thanks > > > "Andrew Kennard" <b@a.com> wrote in message > news:eFKIgglBIHA.5868@TK2MSFTNGP05.phx.gbl... >> Just de installed and reinstalled express without the user instances box >> checked but no difference ? >> >> Thanks >> >> Andrew >> >> "Andrew Kennard" <b@a.com> wrote in message >> news:uLRFNSlBIHA.3916@TK2MSFTNGP02.phx.gbl... >>> Andrew >>> >>> Thanks for your reply. >>> >>> Sorry I should have been clearer both these machines are stand alone and >>> not connected to a server >>> >>> When Express is installed it sounds like it matters wether the "enable >>> user instances" is checked ? >>> >>> Thanks >>> >>> Andrew >>> >>> >>> >>> "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message >>> news:eOWQ2JgBIHA.1356@TK2MSFTNGP03.phx.gbl... >>>> It has nothing to do with Express really it is the fact you have more >>>> than 1 SQL Server instance on the server. By default the 1st instance >>>> is the "Default" instance and takes on the name of the server. Any >>>> additional instances must be "Named" Instances which are referenced by >>>> using the server name and the instance name. (Local) only applies to a >>>> default instance. The bottom line is that you need a way to tell one >>>> instance from another and that is what the named instances do. Have a >>>> look in BOL for more details but here are some links specific to >>>> Express that may be helpful: >>>> >>>> http://msdn2.microsoft.com/en-us/library/ms345154.aspx Express >>>> Overview >>>> http://msdn2.microsoft.com/en-us/library/ms165672.aspx Comparing >>>> Express with MSDE >>>> http://msdn2.microsoft.com/en-us/library/bb264564.aspx User >>>> Instances >>>> http://betav.com/blog/billva/2006/06/getting_and_staying_connected.html >>>> Getting & Staying Connected >>>> http://msdn2.microsoft.com/en-us/library/ms345318.aspx Tutorial on >>>> connecting >>>> http://www.datamasker.com/SSE2005_NetworkCfg.htm Configuring >>>> Express for Remote Access >>>> https://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx >>>> Configuring Remote Access >>>> http://www.kbalertz.com/Feedback_914277.aspx Configuring SQL2005 for >>>> remote access >>>> http://msdn2.microsoft.com/en-us/library/bb264562.aspx Embedding >>>> Express in Apps >>>> http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796&DisplayLang=en >>>> SSMS Express >>>> http://blogs.msdn.com/rogerwolterblog/archive/2006/04/13/575974.aspx >>>> Backing up Express >>>> >>>> -- >>>> Andrew J. Kelly SQL MVP >>>> Solid Quality Mentors >>>> >>>> >>>> "Andrew Kennard" <b@a.com> wrote in message >>>> news:uyHegRfBIHA.5328@TK2MSFTNGP05.phx.gbl... >>>>> Hi All >>>>> >>>>> I have one machine that has the SQL Dev edition on and another that >>>>> uses SQL Express >>>>> >>>>> On the SQL Dev machine using a server name of (local) works fine >>>>> >>>>> On the machine that uses SQL Express this does not work and I have to >>>>> use COMPUTERNAME\SQLEXPRESS >>>>> >>>>> Any idea on why this might be ? >>>>> >>>>> Can SQL express be connected to using (local) ? >>>>> >>>>> Thanks in advance >>>>> >>>>> Andrew >>>>> >>>>> >>>> >>> >>> >> >> > >
Don't see what you're looking for? Try a search.
|
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
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |