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 7 1234
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" <sg@simongare.com> wrote in message
news:e$*************@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
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" <vb******@community.nospam> wrote in message
news:Oq**************@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" <sg@simongare.com> wrote in message news:e$*************@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.
--
Get a powerful web, database, application, and email hosting with KJM
Solutions http://www.kjmsolutions.com
"SIMON GARE" <sg@simongare.com> wrote in message
news:Oq****************@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" <vb******@community.nospam> wrote in message news:Oq**************@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" <sg@simongare.com> wrote in message news:e$*************@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
"vbnetdev" <vb******@community.nospam> wrote in message
news:%2****************@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" <sg@simongare.com> wrote in message news:Oq****************@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" <vb******@community.nospam> wrote in message news:Oq**************@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" <sg@simongare.com> wrote in message news:e$*************@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.
--
Get a powerful web, database, application, and email hosting with KJM
Solutions http://www.kjmsolutions.com
"SIMON GARE" <sg@simongare.com> wrote in message
news:%2***************@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" <vb******@community.nospam> wrote in message news:%2****************@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" <sg@simongare.com> wrote in message news:Oq****************@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" <vb******@community.nospam> wrote in message > news:Oq**************@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" <sg@simongare.com> wrote in message >> news:e$*************@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
"vbnetdev" <vb******@community.nospam> wrote in message
news:OQ**************@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" <sg@simongare.com> wrote in message news:%2***************@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" <vb******@community.nospam> wrote in message news:%2****************@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" <sg@simongare.com> wrote in message news:Oq****************@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" <vb******@community.nospam> wrote in message > news:Oq**************@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" <sg@simongare.com> wrote in message >> news:e$*************@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 >> > >> > >> >> > >
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Bennett Haselton |
last post by:
I want to get an ASP.Net hosting account with my ISP, and I'm trying
to find out what level of access to the server is requried in order
for me to view the server in Server Explorer in Visual...
|
by: svdh2 |
last post by:
I have been looking at a problem the entire week in access, I have
still not been able to find a solution. Hope that you could maybe tell
where to look
Concerns the link between Access and Word....
|
by: svdh |
last post by:
I have posed a question last saturday and have advanced alot in the
meantime. But I am still not there
Problem is that I try to merging various fields from various tables in
one document in Word...
|
by: ZRexRider |
last post by:
Hi,
I have an application that uses MS-SQL Linked tables. I have a utility
routine that drops all links and re-establishes them. It works great
when my connection string is a DSN connection...
|
by: Ahmet Karaca |
last post by:
Hi.
myds.Reset();
mycommand.SelectCommand.CommandText=
"Select att1 from Ing as Ingredient, Pro as Product "+
"where Pro.ad='apple' and Pro.id=Ing.id";
mycommand.Fill(myds, "Product"); // Here...
|
by: Joe Van Meer |
last post by:
Hi,
Is the datalist meant for one table or can I use it to display information
from 2 different tables? Or should I be looking at a datagrid instead?
I began my code and kinda ran into a snag...
|
by: Bennett Haselton |
last post by:
In Visual Studio .Net 2002 Server Explorer, if I add a new connection
under "Data Connections", I can specify a remote server name and the
username and password that I want to use, but then when...
|
by: SIMON GARE |
last post by:
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.
...
|
by: peter.konda |
last post by:
Hello!
I have been busting my head with a problem, that goes like this:
1. with a first ajax call to the server(apache 2.0 + php), I create a
temporary table like this:
create temporary table...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
| |