Can I install both version of SQL server 2000 & 2005 on my Computer ?

I now know only I can install both .Net 1.1 and 2.0 on one computer

but I don't know, Can I do it on SQL Server ?

Please advise me...

You cannot have SQL 2000 and SQL 2005 running in the same computer.

Cheers

Al

|||Yes you can. SQL Servers run under their own process, and different instances maintain their own memory space. You're fine to run both on one server, though I dont recomend it for a production enviroment.|||

When you try, there is an error from the installer! How do you get around that?

Cheers

Al

|||

albertpascual:

When you try, there is an error from the installer! How do you get around that?

Cheers

Al

EDIT

You can if you install 2000 before 2005, companies run different versions on the network as of last year you can still download 6.5 from MSDN. And yes I have run both in one box during the SQL Server 2005 roll out.

|||Hi Albert, I have a machine which first has SQL2005 installed and then I added SQL2000 to it, without any problem. Do you remember what's the error you got from the installer?|||

Yes, something like you cannot install SQL 2005 when another instance is already installed.

The other instance was SQL 2000, and that happend to me at the SQL 2005 CTP version. I have never tried with the release version. Are you telling me that now is all possible?

|||

albertpascual:

Yes, something like you cannot install SQL 2005 when another instance is already installed.

The other instance was SQL 2000, and that happend to me at the SQL 2005 CTP version. I have never tried with the release version. Are you telling me that now is all possible?

The CTPs were bad one CTP between beta 2 and 3 cost me a hard drive and the OS that came with it, back then it takes a while to find the Management Studios all that changed with the final product, you can even get a child to install it but I have not tried it. it is very easy now. But 2000 remains ignore Windows questions just answer those relevant to you.

|||

You are correct, took me a long time to finish the installation of SQL 2005 CTP, the release version was fast and easy on a clean computer. I already removed all my SQL 2000 from any computer, I only use SQL 2005, love the speed!

I am glad that people can install both in the same machine now. Some day I may try that instead of just upgrading it.

Cheers

Al

Can I Have Link Between Several servers

hello all

I have a web application(asp.net) and Database(sql server 2005) .

we have installed them on several servers.

now we want to have a connection between apllication on one server to a database on another server .

for example we have Server(A) and Server(B) the DataBases and Web apllications on two server are the same.

sometimes the Apllication on server(A) must connect to database on server(B).

whats the solution plz?

note that the number of servers can be inceased in the future this mean the number of servers are not fixed.

thanks

Use the function sp_linkedServer of the SQL to link the borh servers.

helped?

Regards

Can I Have link Between Several Servers

hello all

I have a web application(asp.net) and Database(sql server 2005) .

we have installed them on several servers.

now we want to have a connection between apllication on one server to a database on another server .

for example we have Server(A) and Server(B) the DataBases and Web apllications on two server are the same.

sometimes the Apllication on server(A) must connect to database on server(B).

whats the solution plz?

note that the number of servers can be inceased in the future this mean the number of servers are not fixed.

thanks

Not sure I follow -- do you mean you have 2 different database serves that should mirror each other, ie, the data is the same and updates on one should be mirrored on the other?

|||

You have a database in the server A .. connect to it by using ConnectionStringA , and any need data from Server B .. use another ConnectionString (e.g. ConnectionStringB).

So, in the web.config file you will have tow ConnectionStrings (A & B).. when to connect to the database in the same server use StringConnectionA and the other used to connect to the database in the another server (server B) - called ConnectionString B.

Good luck.

|||

thank you

for Contributor : i have defrerent data in each databas i cant use replication

for Participant : i must connect to different web server .

i get it that i must to use splinkserver to link servers

thanks forever.

can I export tables so that existing tables in destination database will be modified?

I'm working on an ASP.Net project where I want to test code on a local
machine using a local database as a back-end, and then export it to
the production machine where it uses the hosting provider's SQL Server
database on the back-end. Is there a way to export tables from one
SQL Server database to another in such a way that if a table already
exists in the destination database, it will be updated to reflect the
changes to the local table, without existing data in the destination
table being lost? e.g. suppose I change some tables in my local
database by adding new fields. Can I "export" these changes to the
destination database so that the new fields will be added to the
destination tables (and filled in with default values), without losing
data in the destination tables?

If I run the DTS Import/Export Wizard that comes with SQL Server and
choose "Copy table(s) and view(s) from the source database" and choose
the tables I want to copy, there is apparently no option *not* to copy
the data, and since I don't want to copy the data, that choice doesn't
work. If instead of "Copy table(s) and view(s) from the source
database", I choose "Copy objects and data between SQL Server
databases", then on the following options I can uncheck the "Copy
Data" box to prevent data being copied. But for the "Create
Destination Objects" choices, I have to uncheck "Drop destination
objects first" since I don't want to lose the existing data. But when
I uncheck that and try to do the copy, I get collisions between the
properties of the local table and the existing destination table,
e.g.:
"Table 'wbuser' already has a primary key defined on it."

Is there no way to do what I want using the DTS Import/Export Wizard?
Can it be done some other way?

-Bennett"Bennett Haselton" <bennett@.peacefire.org> wrote in message
news:e614455c.0411160123.294dfd10@.posting.google.c om...
> I'm working on an ASP.Net project where I want to test code on a local
> machine using a local database as a back-end, and then export it to
> the production machine where it uses the hosting provider's SQL Server
> database on the back-end. Is there a way to export tables from one
> SQL Server database to another in such a way that if a table already
> exists in the destination database, it will be updated to reflect the
> changes to the local table, without existing data in the destination
> table being lost? e.g. suppose I change some tables in my local
> database by adding new fields. Can I "export" these changes to the
> destination database so that the new fields will be added to the
> destination tables (and filled in with default values), without losing
> data in the destination tables?

In a word, no.

I'd suggest take the same version controlled scripts (you are of course
using version control, right? :-) you used to make the changes in Dev and
run those against the Prod server.

> If I run the DTS Import/Export Wizard that comes with SQL Server and
> choose "Copy table(s) and view(s) from the source database" and choose
> the tables I want to copy, there is apparently no option *not* to copy
> the data, and since I don't want to copy the data, that choice doesn't
> work. If instead of "Copy table(s) and view(s) from the source
> database", I choose "Copy objects and data between SQL Server
> databases", then on the following options I can uncheck the "Copy
> Data" box to prevent data being copied. But for the "Create
> Destination Objects" choices, I have to uncheck "Drop destination
> objects first" since I don't want to lose the existing data. But when
> I uncheck that and try to do the copy, I get collisions between the
> properties of the local table and the existing destination table,
> e.g.:
> "Table 'wbuser' already has a primary key defined on it."
> Is there no way to do what I want using the DTS Import/Export Wizard?
> Can it be done some other way?
> -Bennett|||"Greg D. Moore \(Strider\)" <mooregr_deleteth1s@.greenms.com> wrote in message news:<7Mnmd.16$1u.15@.twister.nyroc.rr.com>...
> "Bennett Haselton" <bennett@.peacefire.org> wrote in message
> news:e614455c.0411160123.294dfd10@.posting.google.c om...
> > I'm working on an ASP.Net project where I want to test code on a local
> > machine using a local database as a back-end, and then export it to
> > the production machine where it uses the hosting provider's SQL Server
> > database on the back-end. Is there a way to export tables from one
> > SQL Server database to another in such a way that if a table already
> > exists in the destination database, it will be updated to reflect the
> > changes to the local table, without existing data in the destination
> > table being lost? e.g. suppose I change some tables in my local
> > database by adding new fields. Can I "export" these changes to the
> > destination database so that the new fields will be added to the
> > destination tables (and filled in with default values), without losing
> > data in the destination tables?
> In a word, no.
> I'd suggest take the same version controlled scripts (you are of course
> using version control, right? :-) you used to make the changes in Dev and
> run those against the Prod server.

Uh, no... my "script" is that I move the mouse pointer over the
"wbuser" table in Server Explorer in VS .Net, right-click, pick
"Design Table", and add columns that way :)

So I guess I'll just have to remember to run that "script" against the
Prod database whenever I make any changes.

Still, I would have thought that what I was trying, would be a pretty
common thing for people to want to do... surprised it's not built-in.

-Bennett|||Bennett Haselton (bennett@.peacefire.org) writes:
> Uh, no... my "script" is that I move the mouse pointer over the
> "wbuser" table in Server Explorer in VS .Net, right-click, pick
> "Design Table", and add columns that way :)
> So I guess I'll just have to remember to run that "script" against the
> Prod database whenever I make any changes.
> Still, I would have thought that what I was trying, would be a pretty
> common thing for people to want to do... surprised it's not built-in.

There are third-party tools. Red Gate's SQL Compare is popular.

One reason that this is not built-in is that changes to tables is far
from always something that can be performed automatically. In our shop
we keep all table definitions under source control. To generate an update
script we have a tool that reads SourceSafe between two labels to load
all new and changed objects. For changed tables you get a script that
copies data from the old definition to the new, but this script is really
only a template. In many cases I need to change the script, because a
new column is supposed be initiated with some values derived from
other columns or tables. And there might be even wilder changes.

Point and click may be convenient, but for something which is to be
run several times needs to be automized to be sure that all are updates
are carried out the same way. Thus, you need a script.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Can I edit SDF files without full SQL Server license?

I'm trying to open an SDF file. After many searches on the net, it appears that there are two ways to do this:

Open the file in VS 2005 Open the file in SQL Server Management StudioI don't have, and don't plan to purchase, a license to full SQL Server 2005. I do have Visual Studio 2005 Pro. When I open an SDF file in Visual Studio, I get the following (oh so informative) error:

The operation could not be completed. Unspecified error

Since I don't have full SQL server, I downloaded SQL Server Management Studio Express. There's one major problem: the Server type combo box is disabled in the "Connect to Server" dialog. Try as I might, I can find no mention anywhere as to why this is the case. I'm guessing that functionality isn't supported in the Express version of the tool, but as far as I can tell, nobody thinks it might perhaps be reasonable to document why this combo box is disabled. It certainly doesn't show up in the document that shows up when I click the help button on this dialog.

Could somebody at Microsoft please tell me if it is even possible to edit these files without buying a full SQL Server license? I'm trying to use SQL Server Compact Edition to replace legacy code that uses an MDB file (via ADO) for a desktop application. From everything I have read, this is the officially recommended thing to do. But if I now have to buy a full SQL Server lincense to accomplish what used to be a simple double click on an MDB file, then there's something seriously wrong.

It turns out that my problem was the fact that I didn't have Service Pack 2 installed for SQL Server Management Studio Express, although installing that (along with making sure everything else on my system was up-to-date via Microsoft Update) didn't solve the Visual Studio error. I do have SP 1 installed for VS 2005.
sql

can i Display Database report from SQL 2005 using .Net 2005 ?

Can I generate database report from SQL 2005 using .Net 2005 ?

I want report contain the following:

1. How many schemas I have in database.

2. Display schemas list with its information.

I need the SQL Statement or query that return the above result.

Best regards,

Z. A. A.

Hi,

this should be something like:

Select * FROM sys.schemas

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Can I Deploy a report to a client who doesn't have SQL server license.

How can I Deploy a report with my visual Studio.Net application to a company
who doesn't have SQL server license?
I plan to use SQL Server 2005 Express.SQL Server Express does not yet have support for this. Supposedly Q1. Then
the data needs to reside locally as well.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Roberto Hernández" <robertohh@.newsgroups.nospam> wrote in message
news:%23uQARosIGHA.1760@.TK2MSFTNGP10.phx.gbl...
> How can I Deploy a report with my visual Studio.Net application to a
> company who doesn't have SQL server license?
> I plan to use SQL Server 2005 Express.
>|||VS2005 provide a report viewer control which allow you to render reports.
does your application is web or windows based?
"Roberto Hernández" <robertohh@.newsgroups.nospam> wrote in message
news:%23uQARosIGHA.1760@.TK2MSFTNGP10.phx.gbl...
> How can I Deploy a report with my visual Studio.Net application to a
> company who doesn't have SQL server license?
> I plan to use SQL Server 2005 Express.
>|||Hi Roberto,
As Bruce mentioned, the SQL Server reporting service is not available for
EXPRESS edition so far. Also, what's your application's detailed structure,
does it require a local SQL Server instance? If it is just a client
application which can consume reporting service reports through those
remote accessible programming interfaces, we can consider separate the
application from the backend SQL Server database... Thus, there need a
certain DataBase server which have SQL Server 2005 instance installed
already...
Regards,
Steven Cheng
Microsoft Online Support
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
| From: "Jéj? <willgart@.BBBhotmailAAA.com>
| References: <#uQARosIGHA.1760@.TK2MSFTNGP10.phx.gbl>
| Subject: Re: Can I Deploy a report to a client who doesn't have SQL
server license.
| Date: Thu, 26 Jan 2006 21:35:45 -0500
| Lines: 12
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| X-RFC2646: Format=Flowed; Response
| Message-ID: <emzDhpuIGHA.424@.TK2MSFTNGP12.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: modemcable008.41-80-70.mc.videotron.ca 70.80.41.8
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:67651
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| VS2005 provide a report viewer control which allow you to render reports.
| does your application is web or windows based?
|
| "Roberto Hernández" <robertohh@.newsgroups.nospam> wrote in message
| news:%23uQARosIGHA.1760@.TK2MSFTNGP10.phx.gbl...
| > How can I Deploy a report with my visual Studio.Net application to a
| > company who doesn't have SQL server license?
| >
| > I plan to use SQL Server 2005 Express.
| >
|
|
||||RDLC reports doesn't required any server.
its standalone reports generated on the client side, not the server side.
Also, I think that the report control can render RDL reports without using a
reportserver.
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
news:TUqDfawIGHA.1236@.TK2MSFTNGXA02.phx.gbl...
> Hi Roberto,
> As Bruce mentioned, the SQL Server reporting service is not available for
> EXPRESS edition so far. Also, what's your application's detailed
> structure,
> does it require a local SQL Server instance? If it is just a client
> application which can consume reporting service reports through those
> remote accessible programming interfaces, we can consider separate the
> application from the backend SQL Server database... Thus, there need a
> certain DataBase server which have SQL Server 2005 instance installed
> already...
> Regards,
> Steven Cheng
> Microsoft Online Support
> Get Secure! www.microsoft.com/security
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>
>
> --
> | From: "Jéj? <willgart@.BBBhotmailAAA.com>
> | References: <#uQARosIGHA.1760@.TK2MSFTNGP10.phx.gbl>
> | Subject: Re: Can I Deploy a report to a client who doesn't have SQL
> server license.
> | Date: Thu, 26 Jan 2006 21:35:45 -0500
> | Lines: 12
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
> | X-RFC2646: Format=Flowed; Response
> | Message-ID: <emzDhpuIGHA.424@.TK2MSFTNGP12.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: modemcable008.41-80-70.mc.videotron.ca 70.80.41.8
> | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
> | Xref: TK2MSFTNGXA02.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:67651
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | VS2005 provide a report viewer control which allow you to render
> reports.
> | does your application is web or windows based?
> |
> | "Roberto Hernández" <robertohh@.newsgroups.nospam> wrote in message
> | news:%23uQARosIGHA.1760@.TK2MSFTNGP10.phx.gbl...
> | > How can I Deploy a report with my visual Studio.Net application to a
> | > company who doesn't have SQL server license?
> | >
> | > I plan to use SQL Server 2005 Express.
> | >
> |
> |
> |
>

can i create a cube by VB.net

can i create a cube by VB.net?

I wanna a dynamic Cube, so I can not define it in the Analysis Services Project.

So the problems come.

I must deploy and process and compile the cube.

That can be done?

thank you.

Yes. This can be done using AMO (AnalysisServices Management Objects). In your project, add a reference to the AMO DLL and you can see lots of classes exposed.

|||

Can you clarify what you mean by "dynamic cube"? Just making sure that indeed you do need to create the cube programmatically using AMO.

By the way, there's a good sample in C# (which you'll probably be able to work from and translate to VB) at the following path after you install the SQL Server Samples:

C:\Program Files\Microsoft SQL Server\90\samples\Analysis Services\Programmability\AMO\AMOAdventureWorks\CS\AmoAdventureWorks

|||

Thank you for your replies.

AMO can do the work exactly.

END.

Can I connect without server?

Hi,
I have a customers program on my system - Omin 7 as at
http://www.omnis.net/products/omnis7/ - so I can pull the data into an
Access Database. I'd like to do this work at my place not theirs!
Is there anyway I can set up an ODBC connection so that I can read the
files. The .dsn file reads:
[ODBC]
DRIVER=SQL Server
UID=sa
DATABASE=salesteam
WSID=JERRY
APP=Microsoft(R) Windows(R) Operating System
SERVER=NTSERVER
if that helps at all.
I'm running Windows XP Pro. I guess the problem is that I don't have a
server '
Any help would be greatly appreciated, thank you.
JonAre you saying you are running SQL Server on XP? Then it should work
provided you've got file and printer sharing enabled.
If this is not the case, please elaborate on what you are attempting?
Steve
"Jon" <jon@.SPAM_OFFtheexperts.co.uk> wrote in message
news:btk6qv$t3f$1@.hercules.btinternet.com...

quote:

---

> Hi,
> I have a customers program on my system - Omin 7 as at
> http://www.omnis.net/products/omnis7/ - so I can pull the data into an
> Access Database. I'd like to do this work at my place not theirs!
> Is there anyway I can set up an ODBC connection so that I can read the
> files. The .dsn file reads:
> [ODBC]
> DRIVER=SQL Server
> UID=sa
> DATABASE=salesteam
> WSID=JERRY
> APP=Microsoft(R) Windows(R) Operating System
> SERVER=NTSERVER
> if that helps at all.
> I'm running Windows XP Pro. I guess the problem is that I don't have a
> server '
> Any help would be greatly appreciated, thank you.
> Jon
>

---

|||Xref: TK2MSFTNGP08.phx.gbl microsoft.public.sqlserver.odbc:41677
Steve,
I have NOT got sql server running, just XP PRo with IIS.
Is there any way around this - without installing sql server?
Thanks
Jon
"Steve Thompson" <SteveThompson@.nomail.please> wrote in message
news:uNlSD3u1DHA.2184@.TK2MSFTNGP12.phx.gbl...

quote:

---

> Are you saying you are running SQL Server on XP? Then it should work
> provided you've got file and printer sharing enabled.
> If this is not the case, please elaborate on what you are attempting?
> Steve
> "Jon" <jon@.SPAM_OFFtheexperts.co.uk> wrote in message
> news:btk6qv$t3f$1@.hercules.btinternet.com...
>

---

|||"Jon" <jon@.SPAM_OFFtheexperts.co.uk> wrote in message
news:btpipc$mtu$1@.hercules.btinternet.com...

quote:

---

> I have NOT got sql server running, just XP PRo with IIS.

---

It's still not clear to me what you are attempting, I asked you to elaborate
and I'm only getting little tidbits.

quote:

---

> Is there any way around this - without installing sql server?

---

Is the source data you need in SQL Server? You can get the SQL Server 2000
developers edition for $49 USD.
I wish I could provide a better answer, however lack of detail is not
helping...
Steve

quote:

---

> "Steve Thompson" <SteveThompson@.nomail.please> wrote in message
> news:uNlSD3u1DHA.2184@.TK2MSFTNGP12.phx.gbl...
a[QUOTE]
>

---

can I connect asp 1 to sqlserver 2005

Hi All,
I hopen this isnt a stupid question but can I connect asp 1 to sqlserver 2005? i want to update the database used on a ASP.net 1 project, I seem to be able to get it to connect but cant get it to see the tables?
Thanks for any help
LeeHi,
Were you able to try the connection to an SQL 2000, or other DBMS DB? I'm not up to speed on SQL Server 2005 yet (and as it's still hasn't been released, you may be having a problem peculiar to the beta version. Try posting your connection string (with any sensative parts x'ed out), along with more info on the particulars of your project. It always helps to provide enough information. BRN..|||

Hi Brian,

Thanks for helping!.

the connection string I am using in the web config is
<add key="ConnectionString" value="Server=xxxxx\SQLEXPRESS; Network=DBMSSOCN; Database=xxxxxx; Uid=xxxxx; Pwd=xxxxxx;"/>
SqlConnection sqlConn = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
SqlDataAdapter xxxxx= new SqlDataAdapter(strSql, sqlConn);

The error I get is
Invalid object name 'tbBob'
I forgot to mention I am using sql server 2005 express
Lee

|||There are two possible reasons for that, one you are in SQL Server Express without the Express Manager installed and two you are in the developer edition without management studio installed. Both are separate install the management studio is under management tools. Try the link below to download what you need. Hope this helps.
http://forums.asp.net/1069636/ShowPost.aspx|||Hi Caddre,
I am confused sorry...I need express manager to run a web page?
The error I get is from a web page .. the database isnt even on the same machine?
Lee|||No you don't need Express manager to run web pages but you need Express manager to manage SQL Server Express and there is no need for the database to be on the same machine. I am sorry did not intend to confuse you. Try the link below for Microsoft provided SQL permissions tutorial. Hope this helps.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag2/html/paght000010.asp

Can i attach a .NET assembly into SQL 2000 Server as an extended produce?

and how can it be done?See this KB article:INF: Using Extended Stored Procedures or SP_OA Stored Procedures to Load CLR in SQL Server Is Not Supported It is not recommended or supported. You will have to wait for Yukon.

You might also reada blog entry by Clemens Vasters for his thoughts and further explanation of why it is a problem.

Terri

Can I add an autonumber to a view?

Hi, I wish to build a datagrid, in an ASP.NET web page, in which I can display a row from a table and when I press a button it will move forward one row. The table is not currently sorted and I need it to be alpahbetical by surname so I thought if I created a view I could sort the table alphabetically on the 'Surname' column. I know that ADO.NET when used in disconnected mode doesn't have a cursor which remembers the last row it was on so I thought if I could create an autonumber on the view then I could use this in the 'where' clause to tell SQLserver which line I wished to select by taking the previous number and adding one. Is this the best way to do this and if so could some one give advice on how to write the line of the query that will add in an autonumber column

thanks
Johnwhy don't you just use the standard paging method with a pagesize of one?

(no views, don't have autonumbering unless you feel like generating one from a cursor)|||The table has over 100,000 rows in it so I don't wish to pull all these into a dataset as I thought this would be far too big if lots of users were going to use the website at once. I thought using paging it stepped through a dataset not the actual SQL table. I just want a way that I can find the next row each time.

I will look at the paging method. thanks

John

Can i add a back button on report view ?

Hi all:

I have a asp.net webpage , which has a button to point to a report (by using URL)

Now what i want is another way around , having a back button on report view page, so

that user can click back button to vew the web page.

Is that possible to do it in Report Service?

Thanks

Nick

Hi Nick,

While I would say using the back button in IE is the easy way, there is another way to add a button to a report. Take a look at the custom report item functionality of RS.

Informative link:

http://msdn.microsoft.com/msdnmag/issues/06/10/SQLServer2005/default.aspx

Can i access SQL Login Users in ASP.Net application

Hello All,

I have SQL Server 2005 Installed and i have numbers of SQL Logins users which i want to use in my ASP.Net Application for authentication.

I am using ASP.Net 2.0 (VS.Net 2005).

Can i use the SQL Logins for ASP.Net web application authentication like the way we use Active Directory users?
Thanks in advance,
Wajahat Abbas
http://www.wajahatabbas.com

SQL Authentication is specific to SQL. You will not be able to use SQL Logins as you use Windows users.

See also:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconaspnetauthentication.asp

Thanks
Laurentiu

|||

Thanks for replying.

Ya, i was thinking that with SQL 2005 and ASP.Net release, MS will increase the ASP.Net authenticaiton modes.

As SQL Server 2005 provides very cool features for SQL Users (like bad password, rating), so once we able to consume those things in ASP.Net it would be a peice of cake.
Anyway may be in next releases.

Thanks & Regards,
Wajahat Abbas
http://www.wajahatabbas.com
http://www.dotnetpakistan.com

Can i access SQL Login Users in ASP.Net application

Hello All,

I have SQL Server 2005 Installed and i have numbers of SQL Logins users which i want to use in my ASP.Net Application for authentication.

I am using ASP.Net 2.0 (VS.Net 2005).

Can i use the SQL Logins for ASP.Net web application authentication like the way we use Active Directory users?
Thanks in advance,
Wajahat Abbas
http://www.wajahatabbas.com

SQL Authentication is specific to SQL. You will not be able to use SQL Logins as you use Windows users.

See also:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconaspnetauthentication.asp

Thanks
Laurentiu

|||

Thanks for replying.

Ya, i was thinking that with SQL 2005 and ASP.Net release, MS will increase the ASP.Net authenticaiton modes.

As SQL Server 2005 provides very cool features for SQL Users (like bad password, rating), so once we able to consume those things in ASP.Net it would be a peice of cake.
Anyway may be in next releases.

Thanks & Regards,
Wajahat Abbas
http://www.wajahatabbas.com
http://www.dotnetpakistan.com

Can I access sql 2000 from machine having sql2005

Dear All,

I am developing a network application in asp.net. The database is in local machine having sql 2005. But the user database is already existent. So I am accessing that database which is sql2000. does it give any problem while connecting from sql2005 machine to sql2000. If yes it is giving me error as follows:

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 connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)

connection string is :

"Data Source=192.168.1.16,1433;Network Library=DBMSSOCN;Initial Catalog=mycatalog;User ID=myuserid;Password=mypwd;"

Please correct me if I am wrong.

Thanks and Regards.

Fazal

This indicates that your TCP/IP was not enabled or your sql server was not listening on the appropriate port.

|||

Go to "Microsoft SQL Server 2005" in programm files => onfiguration Tools =>SQL Server Surface Area Configuration =>first option=>Remote Connections

and here allow remote connection = Use both TCP/IP and name pipes => OK

After that you must restart SQL Server 2005 in order to apply the modification and try againa

Popa IUlia

_____________________

MCP.MCAD.MCSD

Can connect to sqlexpress via asp.net but not via asp

I can connect to a sqlexpress database using aspx (asp.net 2.0) pages
but not via classic asp pages. Both the asp and aspx pages are within
the same website. The sqlexpress database is also on the same server.
I have tried using a variety of connection strings within my asp pages,
including dsn, dsn-less, windows authentication, sql authentication
etc. (The sql express database by the way has mixed authenatication and
both work fine)
The errors I am getting are the following:
1. When I put a windows authentication string in my asp
page I get this error:
************
Provider error '80040e21'
Multiple-step OLE DB operation generated errors. Check
each OLE DB status value, if available. No work was done.
?, line 0
***************
2. When I use a sql authenticaion string, I get this
error:
********************
Microsoft OLE DB Provider for ODBC Drivers
error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not
found and no default driver specified
?, line 0
**********************
3. When I use a DSN connection string (with the DSN
connecting successfully within the ODBC utility) I get
this error:
******************
Microsoft OLE DB Provider for ODBC Drivers
error '80004005'
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot
open database "xxxx" requested by the login. The login
failed.
?, line 0
***********************
As mentioned before I have no problems in connecting to
the database via aspx pages within the same website. I can also
successfully connect to the database via visual web developer or sql
express manager on the same machine.
Any ideas?
Sorry, solved this!
|||You took the time to post that you found an answer, could you possibly post the solution?
~Another Steve

Quote:

Originally posted by Steve
Sorry, solved this!

Can connect to sqlexpress via asp.net but not via asp

I can connect to a sqlexpress database using aspx (asp.net 2.0) pages
but not via classic asp pages. Both the asp and aspx pages are within
the same website. The sqlexpress database is also on the same server.
I have tried using a variety of connection strings within my asp pages,
including dsn, dsn-less, windows authentication, sql authentication
etc. (The sql express database by the way has mixed authenatication and
both work fine)
The errors I am getting are the following:
1. When I put a windows authentication string in my asp
page I get this error:
************
Provider error '80040e21'
Multiple-step OLE DB operation generated errors. Check
each OLE DB status value, if available. No work was done.
?, line 0
***************
2. When I use a sql authenticaion string, I get this
error:
********************
Microsoft OLE DB Provider for ODBC Drivers
error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not
found and no default driver specified
?, line 0
**********************
3. When I use a DSN connection string (with the DSN
connecting successfully within the ODBC utility) I get
this error:
******************
Microsoft OLE DB Provider for ODBC Drivers
error '80004005'
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot
open database "xxxx" requested by the login. The login
failed.
?, line 0
***********************
As mentioned before I have no problems in connecting to
the database via aspx pages within the same website. I can also
successfully connect to the database via visual web developer or sql
express manager on the same machine.
Any ideas?Sorry, solved this!|||You took the time to post that you found an answer, could you possibly
post the solution?
~Another Steve
Steve wrote:
> *Sorry, solved this! *
larmores
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message1889178.html

Can ASP.net 2.0 be connected with SQL Server 2000?

using vs2005 to build web pages of asp.net 2.0, The database is SQL Server 2000,.But I always fail to connect.

using the following configuration in web.config:

<appSettings>
<add key="DSN_student" value="server=(local);uid=admin;pwd=123456;database=network_course"/>
</appSettings>

I also failed to connect using the following configuration in web.config:

<add name="network_courseConnectionString1" connectionString="Data Source=(local);Initial Catalog=network_course;User ID=admin;Password=123456;"
providerName="System.Data.SqlClient" />

I am a beginner from China and eager to get answers! Thank you!

Can you post the error you got and the code?

Regards

|||To answer your question, yes. You can use VS2005 with SQL Server 2000. Looking at your second connection string seems like it should work. You might add "Integrated Security=false" in the connect string attributes, but I believe that is the default.

Can AMO be used on VB.Net

Hi,

I want to program the Analysis Roles in AMO. Can I use VB.Net? What is the reference that I have to add to my project? Can you provide a simple sample connection.

Thanks a lot!

cherriesh

Hello,

you can find a kind of tutorial about AMO here

http://msdn2.microsoft.com/en-us/library/ms345081.aspx

HTH

J?rg