|
web
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
No tables visible in SQL Server connectioni am setting up an ASP.NET site and have connected to the SQL Server successfully. When I click on the connection it shows tables 'none' ?? I know there are tables just cant see them. When I set up an ASP site and connect to the SQL with DNS all tables are visible. I have spent a whole day on this tried everything. Tools Dreamweaver MX Server Windows Small Business Server 2003 DB SQL Server 2005 Language ASP.NET VB Regards Simon are you logging in as an id that is not sa? Are you able to create a new
database? -- Show quoteHide quoteGet a powerful web, database, application, and email hosting with KJM Solutions http://www.kjmsolutions.com "SIMON GARE" <s*@simongare.com> wrote in message news:e$vHSraNGHA.420@tk2msftngp13.phx.gbl... > Hi, > > i am setting up an ASP.NET site and have connected to the SQL Server > successfully. > > When I click on the connection it shows tables 'none' ?? I know there are > tables just cant see them. > > When I set up an ASP site and connect to the SQL with DNS all tables are > visible. > > I have spent a whole day on this tried everything. > > Tools Dreamweaver MX > Server Windows Small Business Server 2003 > DB SQL Server 2005 > Language ASP.NET VB > > Regards > Simon > > I am logging in as Administartor because I couldnt find the password for sa,
is that the problem? If so, what do I log in as ? Regards Simon Show quoteHide quote "vbnetdev" <vbnetdev@community.nospam> wrote in message news:Oqj1htaNGHA.2644@TK2MSFTNGP10.phx.gbl... > are you logging in as an id that is not sa? Are you able to create a new > database? > > -- > Get a powerful web, database, application, and email hosting with KJM > Solutions > http://www.kjmsolutions.com > > > > "SIMON GARE" <s*@simongare.com> wrote in message > news:e$vHSraNGHA.420@tk2msftngp13.phx.gbl... > > Hi, > > > > i am setting up an ASP.NET site and have connected to the SQL Server > > successfully. > > > > When I click on the connection it shows tables 'none' ?? I know there are > > tables just cant see them. > > > > When I set up an ASP site and connect to the SQL with DNS all tables are > > visible. > > > > I have spent a whole day on this tried everything. > > > > Tools Dreamweaver MX > > Server Windows Small Business Server 2003 > > DB SQL Server 2005 > > Language ASP.NET VB > > > > Regards > > Simon > > > > > > I am betting your sa password is blank (shudder). Try leaving the password
blank. Your login needs to be granted permissions to access databases. Administrators on the machine do not automatically have rights unless assigned specifically. -- Show quoteHide quoteGet a powerful web, database, application, and email hosting with KJM Solutions http://www.kjmsolutions.com "SIMON GARE" <s*@simongare.com> wrote in message news:Oq4AU%23gNGHA.2912@tk2msftngp13.phx.gbl... >I am logging in as Administartor because I couldnt find the password for >sa, > is that the problem? > > If so, what do I log in as ? > > Regards > Simon > > > "vbnetdev" <vbnetdev@community.nospam> wrote in message > news:Oqj1htaNGHA.2644@TK2MSFTNGP10.phx.gbl... >> are you logging in as an id that is not sa? Are you able to create a new >> database? >> >> -- >> Get a powerful web, database, application, and email hosting with KJM >> Solutions >> http://www.kjmsolutions.com >> >> >> >> "SIMON GARE" <s*@simongare.com> wrote in message >> news:e$vHSraNGHA.420@tk2msftngp13.phx.gbl... >> > Hi, >> > >> > i am setting up an ASP.NET site and have connected to the SQL Server >> > successfully. >> > >> > When I click on the connection it shows tables 'none' ?? I know there > are >> > tables just cant see them. >> > >> > When I set up an ASP site and connect to the SQL with DNS all tables >> > are >> > visible. >> > >> > I have spent a whole day on this tried everything. >> > >> > Tools Dreamweaver MX >> > Server Windows Small Business Server 2003 >> > DB SQL Server 2005 >> > Language ASP.NET VB >> > >> > Regards >> > Simon >> > >> > >> >> > > Thanks for this help before i forget,
I tried that but comes back Login Failed for user sa, see blow config Tried this first "Persist Security Info=False; Data Source=SBS2003; Initial Catalog=TobiasNET; User ID=sa; Password=" Then "Persist Security Info=False; Data Source=SBS2003; Initial Catalog=TobiasNET; User ID=sa" Any suggestions? Simon Show quoteHide quote "vbnetdev" <vbnetdev@community.nospam> wrote in message news:%235UEMXhNGHA.3408@TK2MSFTNGP14.phx.gbl... > I am betting your sa password is blank (shudder). Try leaving the password > blank. > > Your login needs to be granted permissions to access databases. > Administrators on the machine do not automatically have rights unless > assigned specifically. > > -- > Get a powerful web, database, application, and email hosting with KJM > Solutions > http://www.kjmsolutions.com > > > > "SIMON GARE" <s*@simongare.com> wrote in message > news:Oq4AU%23gNGHA.2912@tk2msftngp13.phx.gbl... > >I am logging in as Administartor because I couldnt find the password for > >sa, > > is that the problem? > > > > If so, what do I log in as ? > > > > Regards > > Simon > > > > > > "vbnetdev" <vbnetdev@community.nospam> wrote in message > > news:Oqj1htaNGHA.2644@TK2MSFTNGP10.phx.gbl... > >> are you logging in as an id that is not sa? Are you able to create a new > >> database? > >> > >> -- > >> Get a powerful web, database, application, and email hosting with KJM > >> Solutions > >> http://www.kjmsolutions.com > >> > >> > >> > >> "SIMON GARE" <s*@simongare.com> wrote in message > >> news:e$vHSraNGHA.420@tk2msftngp13.phx.gbl... > >> > Hi, > >> > > >> > i am setting up an ASP.NET site and have connected to the SQL Server > >> > successfully. > >> > > >> > When I click on the connection it shows tables 'none' ?? I know there > > are > >> > tables just cant see them. > >> > > >> > When I set up an ASP site and connect to the SQL with DNS all tables > >> > are > >> > visible. > >> > > >> > I have spent a whole day on this tried everything. > >> > > >> > Tools Dreamweaver MX > >> > Server Windows Small Business Server 2003 > >> > DB SQL Server 2005 > >> > Language ASP.NET VB > >> > > >> > Regards > >> > Simon > >> > > >> > > >> > >> > > > > > > Do this and let me know if it works.
To reset the sa password, you can make the following: 1. Login to the SQL Server box as the Administrator. 2. Run SQL Server Enterprise Manager. 3. Right-click the server name and choose 'Edit SQL Server Registration properties'. 4. Choose 'Use Windows authentication' and click OK button. 5. Expand a server, expand a Security and click Logins. 6. Double-click the sa login and specify new password on the General tab. -- Show quoteHide quoteGet a powerful web, database, application, and email hosting with KJM Solutions http://www.kjmsolutions.com "SIMON GARE" <s*@simongare.com> wrote in message news:%23KA4gchNGHA.456@TK2MSFTNGP15.phx.gbl... > Thanks for this help before i forget, > > I tried that but comes back Login Failed for user sa, see blow config > > Tried this first > > "Persist Security Info=False; > Data Source=SBS2003; > Initial Catalog=TobiasNET; > User ID=sa; > Password=" > > Then > > "Persist Security Info=False; > Data Source=SBS2003; > Initial Catalog=TobiasNET; > User ID=sa" > > Any suggestions? > > Simon > > > "vbnetdev" <vbnetdev@community.nospam> wrote in message > news:%235UEMXhNGHA.3408@TK2MSFTNGP14.phx.gbl... >> I am betting your sa password is blank (shudder). Try leaving the >> password >> blank. >> >> Your login needs to be granted permissions to access databases. >> Administrators on the machine do not automatically have rights unless >> assigned specifically. >> >> -- >> Get a powerful web, database, application, and email hosting with KJM >> Solutions >> http://www.kjmsolutions.com >> >> >> >> "SIMON GARE" <s*@simongare.com> wrote in message >> news:Oq4AU%23gNGHA.2912@tk2msftngp13.phx.gbl... >> >I am logging in as Administartor because I couldnt find the password for >> >sa, >> > is that the problem? >> > >> > If so, what do I log in as ? >> > >> > Regards >> > Simon >> > >> > >> > "vbnetdev" <vbnetdev@community.nospam> wrote in message >> > news:Oqj1htaNGHA.2644@TK2MSFTNGP10.phx.gbl... >> >> are you logging in as an id that is not sa? Are you able to create a > new >> >> database? >> >> >> >> -- >> >> Get a powerful web, database, application, and email hosting with KJM >> >> Solutions >> >> http://www.kjmsolutions.com >> >> >> >> >> >> >> >> "SIMON GARE" <s*@simongare.com> wrote in message >> >> news:e$vHSraNGHA.420@tk2msftngp13.phx.gbl... >> >> > Hi, >> >> > >> >> > i am setting up an ASP.NET site and have connected to the SQL Server >> >> > successfully. >> >> > >> >> > When I click on the connection it shows tables 'none' ?? I know >> >> > there >> > are >> >> > tables just cant see them. >> >> > >> >> > When I set up an ASP site and connect to the SQL with DNS all tables >> >> > are >> >> > visible. >> >> > >> >> > I have spent a whole day on this tried everything. >> >> > >> >> > Tools Dreamweaver MX >> >> > Server Windows Small Business Server 2003 >> >> > DB SQL Server 2005 >> >> > Language ASP.NET VB >> >> > >> >> > Regards >> >> > Simon >> >> > >> >> > >> >> >> >> >> > >> > >> >> > > Thank you problem solved.
Regards Simon Show quoteHide quote "vbnetdev" <vbnetdev@community.nospam> wrote in message news:OQc2yNiNGHA.3936@TK2MSFTNGP10.phx.gbl... > Do this and let me know if it works. > > To reset the sa password, you can make the following: > > 1. Login to the SQL Server box as the Administrator. > 2. Run SQL Server Enterprise Manager. > 3. Right-click the server name and choose 'Edit SQL Server Registration > properties'. > 4. Choose 'Use Windows authentication' and click OK button. > 5. Expand a server, expand a Security and click Logins. > 6. Double-click the sa login and specify new password on the General tab. > > -- > Get a powerful web, database, application, and email hosting with KJM > Solutions > http://www.kjmsolutions.com > > > > "SIMON GARE" <s*@simongare.com> wrote in message > news:%23KA4gchNGHA.456@TK2MSFTNGP15.phx.gbl... > > Thanks for this help before i forget, > > > > I tried that but comes back Login Failed for user sa, see blow config > > > > Tried this first > > > > "Persist Security Info=False; > > Data Source=SBS2003; > > Initial Catalog=TobiasNET; > > User ID=sa; > > Password=" > > > > Then > > > > "Persist Security Info=False; > > Data Source=SBS2003; > > Initial Catalog=TobiasNET; > > User ID=sa" > > > > Any suggestions? > > > > Simon > > > > > > "vbnetdev" <vbnetdev@community.nospam> wrote in message > > news:%235UEMXhNGHA.3408@TK2MSFTNGP14.phx.gbl... > >> I am betting your sa password is blank (shudder). Try leaving the > >> password > >> blank. > >> > >> Your login needs to be granted permissions to access databases. > >> Administrators on the machine do not automatically have rights unless > >> assigned specifically. > >> > >> -- > >> Get a powerful web, database, application, and email hosting with KJM > >> Solutions > >> http://www.kjmsolutions.com > >> > >> > >> > >> "SIMON GARE" <s*@simongare.com> wrote in message > >> news:Oq4AU%23gNGHA.2912@tk2msftngp13.phx.gbl... > >> >I am logging in as Administartor because I couldnt find the password for > >> >sa, > >> > is that the problem? > >> > > >> > If so, what do I log in as ? > >> > > >> > Regards > >> > Simon > >> > > >> > > >> > "vbnetdev" <vbnetdev@community.nospam> wrote in message > >> > news:Oqj1htaNGHA.2644@TK2MSFTNGP10.phx.gbl... > >> >> are you logging in as an id that is not sa? Are you able to create a > > new > >> >> database? > >> >> > >> >> -- > >> >> Get a powerful web, database, application, and email hosting with KJM > >> >> Solutions > >> >> http://www.kjmsolutions.com > >> >> > >> >> > >> >> > >> >> "SIMON GARE" <s*@simongare.com> wrote in message > >> >> news:e$vHSraNGHA.420@tk2msftngp13.phx.gbl... > >> >> > Hi, > >> >> > > >> >> > i am setting up an ASP.NET site and have connected to the SQL Server > >> >> > successfully. > >> >> > > >> >> > When I click on the connection it shows tables 'none' ?? I know > >> >> > there > >> > are > >> >> > tables just cant see them. > >> >> > > >> >> > When I set up an ASP site and connect to the SQL with DNS all tables > >> >> > are > >> >> > visible. > >> >> > > >> >> > I have spent a whole day on this tried everything. > >> >> > > >> >> > Tools Dreamweaver MX > >> >> > Server Windows Small Business Server 2003 > >> >> > DB SQL Server 2005 > >> >> > Language ASP.NET VB > >> >> > > >> >> > Regards > >> >> > Simon > >> >> > > >> >> > > >> >> > >> >> > >> > > >> > > >> > >> > > > > > > Simon,
In the DotNet newsgroups, we use mostly the tool Visual Studio Net. There is one newsgroup (group of) that is an exception for that where is everything used including the notebook and that is the newsgroup. microsoft.public.dotnet.framework.aspnet. Although that you have a lot of crosspost (no problem), do I not see that one. In my opinion do you have with a tool as Dreamweaver the most change in that newsgroup. I hope this helps, Cor 
Other interesting topics
Can opacity/transparency be adjusted within components?
Extract image dimensions (height, width) from Base64 String? DrawIconEx Basic DirectSound question System tray icon Progress bar - No activity Basic How To Question: Class Library or Windows Control Library PropertyChanged event with VB.NET (.NET 1.1) Shrinking Property Editor Description Dns.Resolve: Query Authoritive Server |
|||||||||||||||||||||||
