MS SQL2005 reporting Services + AD. Security question

Hi we run completely Windows shop. So Windows Authentication for Reporting Services is only acceptable solution. Idea is that I assign user in RS manager but they get their security check through AD using Cerberus or whatever it is. We did this setup for intranet web site which consist three machine

PC#1 Domain controller (AD)

PC#2 IIS (intranet web site)

PC#3 MS SQL server. (data)

People logon on web server newer asked for credentials on pull up data from SQL server though IIS being themselves, impersonation.

Now I have setup

PC#1 SSRS, IIS for Reports Server, MS SQL 2k5 for RS metadata etc

PC#2 Domain controller (AD)

PC#3 MS SQL2k (data)

I did same setspn procedure but when I tried to log on Report server it asked me for credentials. Moreover when I provide my logon and password it denies it, accepting only admin credentials.

I went trough few books, number article but nobody describe this scenario in spite it should be most popular solution if network based on Windows.

Any help is really appreciated

I am a way out of my league here, but I don't think it is the Report Server who prompts for credentials but IIS. If you create a web app in IIS configured for Windows authentiction and drop a simple html file in it, i bet you will be prompted for when you try to browse it. As far as what's causing it (excluding configuration issues), you may find the following article useful.|||

Teo,

Thanks a lot. I should read this article monthes ago. It is simple and nice compilation about delegation. I will try my luck with tweaking Report Server config and SPN.

I'll keep posting how I am doing, I think it will be helpfull for everybody who will decide to implement SSRS2k5 similar way

MS SQL Std on Win 2k Pro

Hello.
Is it possible to run MS SQL 2000 Server Standart Edition on Windows 2000
Pro, not Windows 2000 Server ?
bn
> Is it possible to run MS SQL 2000 Server Standart Edition on Windows 2000
> Pro, not Windows 2000 Server ?
No - check possible combinations at
http://www.microsoft.com/sql/evaluat...0/default.asp.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
|||As stated in the link Dejan provided, you need a server OS to run Standard
Edition. However, the Developer Edition provides the same features as the
Enterprise Edition with licensing restrictions and can run on a client OS
like XP Pro.
Hope this helps.
Dan Guzman
SQL Server MVP
"bala nemate" <headq[@.]bamba.lt> wrote in message
news:%23shu6EKlEHA.2140@.TK2MSFTNGP15.phx.gbl...
> Hello.
> Is it possible to run MS SQL 2000 Server Standart Edition on Windows 2000
> Pro, not Windows 2000 Server ?
> bn
>
sql

MS SQL Std on Win 2k Pro

Hello.
Is it possible to run MS SQL 2000 Server Standart Edition on Windows 2000
Pro, not Windows 2000 Server ?
bn> Is it possible to run MS SQL 2000 Server Standart Edition on Windows 2000
> Pro, not Windows 2000 Server ?
No - check possible combinations at
http://www.microsoft.com/sql/evaluation/sysreqs/2000/default.asp.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com|||As stated in the link Dejan provided, you need a server OS to run Standard
Edition. However, the Developer Edition provides the same features as the
Enterprise Edition with licensing restrictions and can run on a client OS
like XP Pro.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"bala nemate" <headq[@.]bamba.lt> wrote in message
news:%23shu6EKlEHA.2140@.TK2MSFTNGP15.phx.gbl...
> Hello.
> Is it possible to run MS SQL 2000 Server Standart Edition on Windows 2000
> Pro, not Windows 2000 Server ?
> bn
>

MS SQL sever 2000 string connection problem

Hi, i'm very new to Web Matrix. I've been following the C# end-end application tutorial exactly but i can't seem to run my application.
The code given in the link below is for MS Access but I'm using MS SQL 2000, so i'm not sure of the syntax for the code provided below (string connectionString...)
Please help..thank u!!

http://www.asp.net/webmatrix/guidedtour/section91/bookrequestcontrol.aspx

string connectionString = @."Provider=Microsoft.Jet.OLEDB.4.0; Data Source=D:\TempProjects\LibraryDatabase.mdb";

public void LoadRequestedBooks(){

try

{

string mySelectQuery = string.Format("SELECT books.* from books, requests where books.bid = requests.bid and requests.mid = {0}", Session["userid"]);

System.Data.OleDb.OleDbConnection myConnection = new System.Data.OleDb.OleDbConnection(connectionString);

System.Data.DataSet myDataSet = new System.Data.DataSet();

System.Data.OleDb.OleDbDataAdapter myOleDbDataAdapter = new System.Data.OleDb.OleDbDataAdapter(mySelectQuery, myConnection);

myOleDbDataAdapter.Fill(myDataSet);

DataGrid1.DataSource = myDataSet.Tables[0];

DataGrid1.DataBind();

myConnection.Close();

}

catch(Exception exp)

{

Label2.Text = "<br>Error: " + exp.Message + "<br>";

}

}Hi,

You may take a look at another section of the Web Matrix tutorial,
which is primarily focus on data access with SQL/MSDE Server:
http://asp.net/webmatrix/tour/section2/newconn.aspx

Colt|||hi again. thanks for the site, but my problem is the database is not storred locally. it's on the server. How should i change the syntax in the following code to suit MS Sql Server2000? Your help will be very much appreciated. Thank you.

string connectionString = @."Provider=Microsoft.Jet.OLEDB.4.0; Data Source=D:\TempProjects\LibraryDatabase.mdb";
public void LoadRequestedBooks(){

try
{

string mySelectQuery = string.Format("SELECT books.* from books, requests where books.bid = requests.bid and requests.mid = {0}", Session["userid"]);
System.Data.OleDb.OleDbConnection myConnection = new System.Data.OleDb.OleDbConnection(connectionString);
System.Data.DataSet myDataSet = new System.Data.DataSet();
System.Data.OleDb.OleDbDataAdapter myOleDbDataAdapter = new System.Data.OleDb.OleDbDataAdapter(mySelectQuery, myConnection);

myOleDbDataAdapter.Fill(myDataSet);
DataGrid1.DataSource = myDataSet.Tables[0];
DataGrid1.DataBind();
myConnection.Close();

}
catch(Exception exp)
{
Label2.Text = "<br>Error: " + exp.Message + "<br>";

}

}|||Hi,

I see.. You can connect to a remote DB server by using its IP address,
E.g. "Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd;"
FYI:http://www.connectionstrings.com

Colt

MS SQL Server vs MySQL question..

I use MS profiler to run traces to diagnose issues/problems with any MS SQL Server database. Is there an equivalent tool when using MySQL database? What about Enterprise Manger and Query Analyzer? Is it fair to assume that the administrative tools available for MySQL will do the job that MS tools do for MS SQL Server with comparable ease?

Thanks.I don't know of any Profiler-like applications for MySQL but I use SQLyog to administer my MySQL databases (http://www.webyog.com).

In my opinion comparing MySQL to MS SQL Server is comparing a bycicle with a Mercedes. They both get you from A to B but that's the only fair comparison. MySQL is a nice database for small non-critical applications but it can't do halve the things that SQL Server can. So tools for MySQL won't do the same as the ones for SQL Server.

Lex

PS. Again, this is my own opinion on the matter. So feel free to contradict :D|||small non-critical applications? whoa

have a look at some of the mysql customers (http://www.mysql.com/customers/), my friend, and you will see some fairly big, critical names

craigslist, slashdot, technorati are small, non-critical?

ticketmaster is small, non-critical?

you've been buying the "open source can't be any good" comic books, haven't you

:)|||In terms of industry support, developer and dba tools, and more importantly vendor support, I think Microsoft SQL Server is the best bang for the buck available. The features available (many of them "out of the box" such as SQL Profiler, Enterprise Manager, Analysis Services, and Reporting Services) are more readily available and well understood than comparable tools for any product currently available, at any price.

This doesn't mean that MySQL is a bad tool, and it emphatically does not mean that it isn't suitable for doing serious work. It does however mean that you need to find support from someone other than the vendor (MySQL AB), which gives you a very low cost of entry, but often a HUGE ongoing cost for the people you need to support the product. For large organizations that need people with "heavy firepower" to support their applications like the ones that R937 pointed out, the cost is irrelevant. They need to have folks that can handle the support on staff 24 by 365 anyway, so they have no additional cost of ownership.

For most of us, the cost of the people needed to support the tools would exceed what the company makes. Many folks choose to live without the support, and hope that they never need it. That has proven to be a fatal assumption for a number of small (under $10 million per year gross revenue) businesses every year.

Microsoft SQL Server isn't a "magic bullet". It won't solve every problem. I don't always recommend it, but for more than 80% of the business use that I see, MS-SQL is the best database tool for the job in my opinion.

-PatP|||Alright, alright, I take back some of the words I said about MySQL. It was after one o'clock at night when I wrote that post and I was feeling rebellious. I overstated the comparison and my humble opinion actually comes close to that of Pat's.

I'm still not fully over the first impression I got when, years back, I learned of MySQL and did some research. I looked up the support for referential integrety and was horrified to read that, not only was that support at the time non-existing but it was stated that it was cumbersome and troublesome and you wouldn't need it.

I tossed it aside and didn't look at it for a few years. When I re-researched it a few years later the support was added and I find the product most agreeable. But aside from the features it lacks in comparison to SQL Server (and Oracle and DB2 and Sybase and ...) I think the most crucial thing is the absence of a big vendor who is and feels responsible for the product. And that's what you need when your core business depends on it!

For the record: I think I'm not biased when it comes to open source or even databases. Oracle is as good a database as Sybase or SQL Server. They all have their weaknesses and strong points (When's MS gonna give me function based idexes and a sequence generator!? ;)). MySQL has it's strongpoints and I will keep using it for the projects I think it is most suitable for.

Lex

PS. is that comic on the same shelve as the "Big commercial companies are all money grabbin' crooks thus open source is the solution for everything" comics? :D

MS SQL Server Run time Error

Hi

We are using MS SQL Server 2000 as back end database for our application. It was working fine certainly we are getting Run time error while try to open this application through front end.

The Error number says that the SQL Transaction Log file is file. find belo the error

Thanks in advance.
S KaliyanI think I missed the error in the post. If this is still unresolved can you resend with the appropriate error?

MS sql server on Unix

Can anyone please reply...
Can you install, run , use ... MS SQL Server on Unix?I guess it is imposible|||ramshree, MSSQL Server will only run on Microsoft operating systems.|||sql on windows is faster anyway

www.tpc.org|||Sorry Ram MS SQL server runs on only Windows platform and not on any other OS.

MS SQL server Insert Error [109]

Greetings!

When I run the following SQL statement in Perl, I get an error
stating:
any help/pointers how this can be resolved?

Thanks,
-Murali

SQL note_insert error: [109] [2] [0] "[Microsoft][ODBC SQL Server
Driver][SQL Server]There are more columns in the INSERT statement than
values specified in the VALUES clause. The number of values in the
VALUES clause must match the number of columns specified in the INSERT
statement."

The perl code:

$sql_stmt1 = "select cast(newid () as varbinary(16)) as notes_id
from cc_test";

if($db_ends->Sql($sql_stmt1))
{
$db_ends->Error();
exit(-1);
}

while($db_ends->FetchRow())
{
undef %Data;
%Data = $db_ends->DataHash();
$notes_id = $Data{"notes_id"};
}

# Prepare the columns for insert

my$updated_detail = "$pn . $cc_ver\n";

my $note_columns = "user_note_id, bio_name, related_tbl_name,
related_string_id, related_int_id, note_type_lkp, notes,
internal_flag, revision_number, obsolete_flag";

my $note_values = "cast(" +$notes_Id + "as binary(16)), Null, Null,
Null, $bfn, 0x74942E5A0A04022800415DE63529D4B7, $notes_detail, 0, 0,
0";

$sql_note_insert = "insert into user_note ($note_columns) values
($note_values)";

if($db_ends->Sql($sql_note_insert))Make sure you delimit all strings with single quotes ('). If one of the
current variables (such as $note_details) contains a comma, then you
will have more "values" than "columns".

If this doesn't work, then please post the actual query you are
submitting to SQL-Server.

Hope this helps,
Gert-Jan

Murali Kanaga wrote:
> Greetings!
> When I run the following SQL statement in Perl, I get an error
> stating:
> any help/pointers how this can be resolved?
> Thanks,
> -Murali
> SQL note_insert error: [109] [2] [0] "[Microsoft][ODBC SQL Server
> Driver][SQL Server]There are more columns in the INSERT statement than
> values specified in the VALUES clause. The number of values in the
> VALUES clause must match the number of columns specified in the INSERT
> statement."
> The perl code:
> $sql_stmt1 = "select cast(newid () as varbinary(16)) as notes_id
> from cc_test";
> if($db_ends->Sql($sql_stmt1))
> {
> $db_ends->Error();
> exit(-1);
> }
> while($db_ends->FetchRow())
> {
> undef %Data;
> %Data = $db_ends->DataHash();
> $notes_id = $Data{"notes_id"};
> }
> # Prepare the columns for insert
> my $updated_detail = "$pn . $cc_ver\n";
> my $note_columns = "user_note_id, bio_name, related_tbl_name,
> related_string_id, related_int_id, note_type_lkp, notes,
> internal_flag, revision_number, obsolete_flag";
> my $note_values = "cast(" +$notes_Id + "as binary(16)), Null, Null,
> Null, $bfn, 0x74942E5A0A04022800415DE63529D4B7, $notes_detail, 0, 0,
> 0";
> $sql_note_insert = "insert into user_note ($note_columns) values
> ($note_values)";
> if($db_ends->Sql($sql_note_insert))sql

MS SQL Server Database Connection Problems

Hi

I can connect successfully to the Microsoft SQL Server "Beauty" (get also nonzero for successfull connection). If i run the application (see code below). I get following Error Message "Illegal Objectname 'TestTabelle' ". I double checked the SQL statement and it should be correct. Even the spelling of TestTabelle is right. For testing purposes I've also included 5-6 data records in the tabel.

I try to connect via ODBC. I've created the database with MS SQL Enterprise Manager. Right Click -> Create New Database. I called it "Test" and created in "Test" a new Table, which is called "TestTabelle".

I found information how i can connect to a ms sql server "Beauty", i've also found how i can connect to a table, BUT where is the information which Database ?`in my case it should be Test.

how can i setup a default database... Cause in my application i can't access my Test Database.... See code below :(

Why is this code BOLD not working if i try to select a database ?

Thank You
Indian

{
CDBVariant value;
char sql_statement [2048] = "";

//CDatabase object "db" created to connect database
CDatabase db;
db.OpenEx(_T("DSN=Beauty;UID=Administrator"), CDatabase::noOdbcDialog);

//CRecordset object "rs" created to access and manipulate database records.
CRecordset rs(&db);
strcpy(sql_statement,_T("SELECT * FROM TestTabelle")); <- NOT WORKING... GETTING ERROR MESSAGE if i use this sql_statement " USE TEST; SELECT * FROM TestTabelle"
rs.Open(CRecordset::forwardOnly,sql_statement);

//Get quantity from Database
int n = rs.GetODBCFieldCount( );
while(!rs.IsEOF())
{
for( int i = 0; i < n; i++ )
{
rs.GetFieldValue("index",value);
m_Buy_List.InsertItem(i,LPCTSTR(value.m_pstring));

rs.GetFieldValue("product",value);
m_Buy_List.SetItemText(i,2,LPCTSTR(value.m_pstring ));

rs.GetFieldValue("price",value);
m_Buy_List.SetItemText(i,3,LPCTSTR(value.m_pstring ));
}
rs.MoveNext( );
}

//Close records access.
rs.Close( );

//Close database connection.
db.Close();

}double-click on Administrator (login) and select the default database from the drop-down box at the bottom of this dialog box.|||Better yet, use a more explicit query. Try:

strcpy(sql_statement,_T("SELECT * FROM Test.TestTabelle"));|||Better yet, use a more explicit query. Try:

strcpy(sql_statement,_T("SELECT * FROM Test.TestTabelle"));|||Sorry. Just replace the line in your code.

You could also skip ODBC, and specify the database in your connection string by using OLEDB.

Try this line in your code to connect to the server...

//CDatabase object "db" created to connect database
CDatabase db;
db.OpenEx(_T("Provider=SQLOLEDB.1;Data Source=Beauty;Initial Catalog=Test;UID=Administrator"), CDatabase::noOdbcDialog);|||i figured it out

thx

MS SQL Server 2000 on Windows 2003 SP1: SP3a or SP4?

Hi,
I want to run MS SQL Server 2000 on Windows Server 2003 SP1. Would SP3a be
just fine for SQL Server or should I apply SP4, which is not yet tested with
the application, and why?
Are there any differences between installing SQL Server 2000 on Windows 2000
Server SP4 and Windows Server 2003 SP1 and what are they, if any?
--
Many thanks,
OskAt a minimum you need 3a. You might want to consider SP4. Make sure that
you take a look at the following pages so that you have the information that
you need to make your own determination:
http://www.microsoft.com/sql/downloads/2000/sp4.asp
http://www.microsoft.com/sql/downloads/2000/sp3.asp
--
Keith
"Oskar" <Oskar@.discussions.microsoft.com> wrote in message
news:BD8FF29E-57A3-4A04-9BF0-6698EF153DE3@.microsoft.com...
> Hi,
> I want to run MS SQL Server 2000 on Windows Server 2003 SP1. Would SP3a be
> just fine for SQL Server or should I apply SP4, which is not yet tested
> with
> the application, and why?
> Are there any differences between installing SQL Server 2000 on Windows
> 2000
> Server SP4 and Windows Server 2003 SP1 and what are they, if any?
> --
> Many thanks,
> Osk
>

MS SQL Server 2000 on Windows 2003 SP1: SP3a or SP4?

Hi,
I want to run MS SQL Server 2000 on Windows Server 2003 SP1. Would SP3a be
just fine for SQL Server or should I apply SP4, which is not yet tested with
the application, and why?
Are there any differences between installing SQL Server 2000 on Windows 2000
Server SP4 and Windows Server 2003 SP1 and what are they, if any?
Many thanks,
OskAt a minimum you need 3a. You might want to consider SP4. Make sure that
you take a look at the following pages so that you have the information that
you need to make your own determination:
http://www.microsoft.com/sql/downloads/2000/sp4.asp
http://www.microsoft.com/sql/downloads/2000/sp3.asp
Keith
"Oskar" <Oskar@.discussions.microsoft.com> wrote in message
news:BD8FF29E-57A3-4A04-9BF0-6698EF153DE3@.microsoft.com...
> Hi,
> I want to run MS SQL Server 2000 on Windows Server 2003 SP1. Would SP3a be
> just fine for SQL Server or should I apply SP4, which is not yet tested
> with
> the application, and why?
> Are there any differences between installing SQL Server 2000 on Windows
> 2000
> Server SP4 and Windows Server 2003 SP1 and what are they, if any?
> --
> Many thanks,
> Osk
>sql

MS SQL Server 2000 on Windows 2003 SP1: SP3a or SP4?

Hi,
I want to run MS SQL Server 2000 on Windows Server 2003 SP1. Would SP3a be
just fine for SQL Server or should I apply SP4, which is not yet tested with
the application, and why?
Are there any differences between installing SQL Server 2000 on Windows 2000
Server SP4 and Windows Server 2003 SP1 and what are they, if any?
Many thanks,
Osk
At a minimum you need 3a. You might want to consider SP4. Make sure that
you take a look at the following pages so that you have the information that
you need to make your own determination:
http://www.microsoft.com/sql/downloads/2000/sp4.asp
http://www.microsoft.com/sql/downloads/2000/sp3.asp
Keith
"Oskar" <Oskar@.discussions.microsoft.com> wrote in message
news:BD8FF29E-57A3-4A04-9BF0-6698EF153DE3@.microsoft.com...
> Hi,
> I want to run MS SQL Server 2000 on Windows Server 2003 SP1. Would SP3a be
> just fine for SQL Server or should I apply SP4, which is not yet tested
> with
> the application, and why?
> Are there any differences between installing SQL Server 2000 on Windows
> 2000
> Server SP4 and Windows Server 2003 SP1 and what are they, if any?
> --
> Many thanks,
> Osk
>

MS SQL Server 2000 Enterprise Edition installation error

My laptop has VS 2005 installed. I am trying to install MS SQL Server 2000 Enterprise Edition, when i run "install database components", it gave error: "MS SQL Server 2000 Enterprise Edition component is not supported on this operating system. Only client components will be available for installation". then when i click on "ok", then "next", when i click on "next" on the "computer name" page, it gave another error: "A previous program installation created pending file operations on the installation moachine. You must restart the computer before running setup". I restarted my laptop following the instruction, but same thing happened when i run the installation. Plz help

Enterprise edition will only install on Server Operating systems, so it won't install on XP.

Any application can set a pending reboot flag in the operating system through a registry key. Sometimes a reboot does not clear the flag. This is what setup is detecting.

To work around the pending reboot issue:
1/ Open Regedit
2/ Find the key "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager"
3/ Rename the "PendingFileRenameOperations" value to "PendingFileRenameOperations2"

|||

thx Jeffery for the quick reply, I was able to install the client components by following your instruction. thx for your help and good luck for 2006 :)

|||Really this was helped very much after changing the registry smoothly sql 2000 installed and working smoothly , thanks ton.|||I've checked that registry location and can't find the listed key in the path listed. Yet, the error persists. I'd love to solve this. If I do I'll edit this post if I can with the results.|||

hi Bob, when u go to "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager", just click on the "Session Manager" folder on the left hand side treeview, then u will find "PendingFileRenameOperations"

|||

I understand what I'm looking for but it's not there at all. There is no 'PendingFileRenameOperations' folder under Session Manager.

I've even did a 'find' for 'PendingFileRenameOperations'. It returned an entry under HKLM\System\ControlSet001\Control\BackupRestore\KeysNotToRestore.

I checked another XP Pro machine I have an it doesn't have the key either.

Got any other clues?

Thanks for your help

|||'PendingFileRenameOperations' is not a folder, it's just a value name. when u left-click on the Session Manager folder on the left, there will be a list shown on the right, u can find the 'PendingFileRenameOperations' in the list.|||

I can't find it as a value in SessionManager or as a folder or anywhere other than in the location indicated above. It's just not there.

I can't seem to find it anywhere. So, I guess what I'm saying is that since it is not 'required' (which it seems to the case since renaming it allows the SQL server to install) and I don't have one, why is it still that I can't install?

|||

Well, that is only for the error "A previous program installation created pending file operations on the installation moachine. You must restart the computer before running setup".

Is that what you are seeing? If not, could you start a *different* thread describing the error that you are seeing?

|||I'm sorry. I checked the KB and these two errors seemed to be lumpped together. I'll start another thread.|||This was a fantastic help! I had this same problem and tried all sorts to solve.
This worked a treat! Cheers :)|||

Thank you, Thank you. This solved my problem. I'm so glad I found you and this posting on Microsoft TechNet. I wasn't even sure how to describe this problem, but am so thankful for your help.

Now, I can finish installing SQL Server and the upgrade Service Packs. Thanks again.

Gary

|||gracias...|||I have tried to change the name of the file in the regedit and I am still receiving the same error that a previous program installtion created pending file operations on the installation machine. You must restart computer before running setup. What do I do now? i ahve restarted 3 times.

MS SQL Server 2000 Enterprise Edition installation error

My laptop has VS 2005 installed. I am trying to install MS SQL Server 2000 Enterprise Edition, when i run "install database components", it gave error: "MS SQL Server 2000 Enterprise Edition component is not supported on this operating system. Only client components will be available for installation". then when i click on "ok", then "next", when i click on "next" on the "computer name" page, it gave another error: "A previous program installation created pending file operations on the installation moachine. You must restart the computer before running setup". I restarted my laptop following the instruction, but same thing happened when i run the installation. Plz help

Enterprise edition will only install on Server Operating systems, so it won't install on XP.

Any application can set a pending reboot flag in the operating system through a registry key. Sometimes a reboot does not clear the flag. This is what setup is detecting.

To work around the pending reboot issue:
1/ Open Regedit
2/ Find the key "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager"
3/ Rename the "PendingFileRenameOperations" value to "PendingFileRenameOperations2"

|||

thx Jeffery for the quick reply, I was able to install the client components by following your instruction. thx for your help and good luck for 2006 :)

|||Really this was helped very much after changing the registry smoothly sql 2000 installed and working smoothly , thanks ton.|||I've checked that registry location and can't find the listed key in the path listed. Yet, the error persists. I'd love to solve this. If I do I'll edit this post if I can with the results.|||

hi Bob, when u go to "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager", just click on the "Session Manager" folder on the left hand side treeview, then u will find "PendingFileRenameOperations"

|||

I understand what I'm looking for but it's not there at all. There is no 'PendingFileRenameOperations' folder under Session Manager.

I've even did a 'find' for 'PendingFileRenameOperations'. It returned an entry under HKLM\System\ControlSet001\Control\BackupRestore\KeysNotToRestore.

I checked another XP Pro machine I have an it doesn't have the key either.

Got any other clues?

Thanks for your help

|||'PendingFileRenameOperations' is not a folder, it's just a value name. when u left-click on the Session Manager folder on the left, there will be a list shown on the right, u can find the 'PendingFileRenameOperations' in the list.|||

I can't find it as a value in SessionManager or as a folder or anywhere other than in the location indicated above. It's just not there.

I can't seem to find it anywhere. So, I guess what I'm saying is that since it is not 'required' (which it seems to the case since renaming it allows the SQL server to install) and I don't have one, why is it still that I can't install?

|||

Well, that is only for the error "A previous program installation created pending file operations on the installation moachine. You must restart the computer before running setup".

Is that what you are seeing? If not, could you start a *different* thread describing the error that you are seeing?

|||I'm sorry. I checked the KB and these two errors seemed to be lumpped together. I'll start another thread.|||This was a fantastic help! I had this same problem and tried all sorts to solve.

This worked a treat! Cheers :)|||

Thank you, Thank you. This solved my problem. I'm so glad I found you and this posting on Microsoft TechNet. I wasn't even sure how to describe this problem, but am so thankful for your help.

Now, I can finish installing SQL Server and the upgrade Service Packs. Thanks again.

Gary

|||gracias...|||I have tried to change the name of the file in the regedit and I am still receiving the same error that a previous program installtion created pending file operations on the installation machine. You must restart computer before running setup. What do I do now? i ahve restarted 3 times.

MS SQL Server 2000 Enterprise Edition installation error

My laptop has VS 2005 installed. I am trying to install MS SQL Server 2000 Enterprise Edition, when i run "install database components", it gave error: "MS SQL Server 2000 Enterprise Edition component is not supported on this operating system. Only client components will be available for installation". then when i click on "ok", then "next", when i click on "next" on the "computer name" page, it gave another error: "A previous program installation created pending file operations on the installation moachine. You must restart the computer before running setup". I restarted my laptop following the instruction, but same thing happened when i run the installation. Plz help

Enterprise edition will only install on Server Operating systems, so it won't install on XP.

Any application can set a pending reboot flag in the operating system through a registry key. Sometimes a reboot does not clear the flag. This is what setup is detecting.

To work around the pending reboot issue:
1/ Open Regedit
2/ Find the key "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager"
3/ Rename the "PendingFileRenameOperations" value to "PendingFileRenameOperations2"

|||

thx Jeffery for the quick reply, I was able to install the client components by following your instruction. thx for your help and good luck for 2006 :)

|||Really this was helped very much after changing the registry smoothly sql 2000 installed and working smoothly , thanks ton.|||I've checked that registry location and can't find the listed key in the path listed. Yet, the error persists. I'd love to solve this. If I do I'll edit this post if I can with the results.|||

hi Bob, when u go to "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager", just click on the "Session Manager" folder on the left hand side treeview, then u will find "PendingFileRenameOperations"

|||

I understand what I'm looking for but it's not there at all. There is no 'PendingFileRenameOperations' folder under Session Manager.

I've even did a 'find' for 'PendingFileRenameOperations'. It returned an entry under HKLM\System\ControlSet001\Control\BackupRestore\KeysNotToRestore.

I checked another XP Pro machine I have an it doesn't have the key either.

Got any other clues?

Thanks for your help

|||'PendingFileRenameOperations' is not a folder, it's just a value name. when u left-click on the Session Manager folder on the left, there will be a list shown on the right, u can find the 'PendingFileRenameOperations' in the list.|||

I can't find it as a value in SessionManager or as a folder or anywhere other than in the location indicated above. It's just not there.

I can't seem to find it anywhere. So, I guess what I'm saying is that since it is not 'required' (which it seems to the case since renaming it allows the SQL server to install) and I don't have one, why is it still that I can't install?

|||

Well, that is only for the error "A previous program installation created pending file operations on the installation moachine. You must restart the computer before running setup".

Is that what you are seeing? If not, could you start a *different* thread describing the error that you are seeing?

|||I'm sorry. I checked the KB and these two errors seemed to be lumpped together. I'll start another thread.|||This was a fantastic help! I had this same problem and tried all sorts to solve.
This worked a treat! Cheers :)|||

Thank you, Thank you. This solved my problem. I'm so glad I found you and this posting on Microsoft TechNet. I wasn't even sure how to describe this problem, but am so thankful for your help.

Now, I can finish installing SQL Server and the upgrade Service Packs. Thanks again.

Gary

|||gracias...|||I have tried to change the name of the file in the regedit and I am still receiving the same error that a previous program installtion created pending file operations on the installation machine. You must restart computer before running setup. What do I do now? i ahve restarted 3 times.

MS SQL Server 2000 Enterprise Edition installation error

My laptop has VS 2005 installed. I am trying to install MS SQL Server 2000 Enterprise Edition, when i run "install database components", it gave error: "MS SQL Server 2000 Enterprise Edition component is not supported on this operating system. Only client components will be available for installation". then when i click on "ok", then "next", when i click on "next" on the "computer name" page, it gave another error: "A previous program installation created pending file operations on the installation moachine. You must restart the computer before running setup". I restarted my laptop following the instruction, but same thing happened when i run the installation. Plz help

Enterprise edition will only install on Server Operating systems, so it won't install on XP.

Any application can set a pending reboot flag in the operating system through a registry key. Sometimes a reboot does not clear the flag. This is what setup is detecting.

To work around the pending reboot issue:
1/ Open Regedit
2/ Find the key "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager"
3/ Rename the "PendingFileRenameOperations" value to "PendingFileRenameOperations2"

|||

thx Jeffery for the quick reply, I was able to install the client components by following your instruction. thx for your help and good luck for 2006 :)

|||Really this was helped very much after changing the registry smoothly sql 2000 installed and working smoothly , thanks ton.|||I've checked that registry location and can't find the listed key in the path listed. Yet, the error persists. I'd love to solve this. If I do I'll edit this post if I can with the results.|||

hi Bob, when u go to "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager", just click on the "Session Manager" folder on the left hand side treeview, then u will find "PendingFileRenameOperations"

|||

I understand what I'm looking for but it's not there at all. There is no 'PendingFileRenameOperations' folder under Session Manager.

I've even did a 'find' for 'PendingFileRenameOperations'. It returned an entry under HKLM\System\ControlSet001\Control\BackupRestore\KeysNotToRestore.

I checked another XP Pro machine I have an it doesn't have the key either.

Got any other clues?

Thanks for your help

|||'PendingFileRenameOperations' is not a folder, it's just a value name. when u left-click on the Session Manager folder on the left, there will be a list shown on the right, u can find the 'PendingFileRenameOperations' in the list.|||

I can't find it as a value in SessionManager or as a folder or anywhere other than in the location indicated above. It's just not there.

I can't seem to find it anywhere. So, I guess what I'm saying is that since it is not 'required' (which it seems to the case since renaming it allows the SQL server to install) and I don't have one, why is it still that I can't install?

|||

Well, that is only for the error "A previous program installation created pending file operations on the installation moachine. You must restart the computer before running setup".

Is that what you are seeing? If not, could you start a *different* thread describing the error that you are seeing?

|||I'm sorry. I checked the KB and these two errors seemed to be lumpped together. I'll start another thread.|||This was a fantastic help! I had this same problem and tried all sorts to solve.

This worked a treat! Cheers :)|||

Thank you, Thank you. This solved my problem. I'm so glad I found you and this posting on Microsoft TechNet. I wasn't even sure how to describe this problem, but am so thankful for your help.

Now, I can finish installing SQL Server and the upgrade Service Packs. Thanks again.

Gary

|||gracias...|||I have tried to change the name of the file in the regedit and I am still receiving the same error that a previous program installtion created pending file operations on the installation machine. You must restart computer before running setup. What do I do now? i ahve restarted 3 times.sql

MS SQL Server 2000 - Run query as a different user

Can we run some query as a different user working with MS SQL Server 2000?
For example if we connected to the DB in the Enterprise Manager as User1,
can we run some query as User2?
We need to select from a VIEW pulling data from some DB, we can encrypt the
text of this view hiding the target tales and their structure on the target
DB. But since the view works with this DB it should have the permissions to
SELECT from this DB, and that gives the green light to the user to see these
tables in the Enterprise Manager.
It would be nice if we could run the queries inside the view under another
user account and then encrypt the view so that the user will see the view as
it works but should never see the DB tables or the text of the view.
Just D.Of course you can do that, this is one of the benefits of the views.
Example:
Make dbo owner of table employees
Create a view owned by dbo to access some of the fields of employee table
Give permissions to user1 to this view
User1 will be able to access the view but not the employees table
Ben Nevarez, MCDBA, OCP
Database Administrator
"Dmitri Shvetsov" wrote:

> Can we run some query as a different user working with MS SQL Server 2000?
> For example if we connected to the DB in the Enterprise Manager as User1,
> can we run some query as User2?
> We need to select from a VIEW pulling data from some DB, we can encrypt th
e
> text of this view hiding the target tales and their structure on the targe
t
> DB. But since the view works with this DB it should have the permissions t
o
> SELECT from this DB, and that gives the green light to the user to see the
se
> tables in the Enterprise Manager.
> It would be nice if we could run the queries inside the view under another
> user account and then encrypt the view so that the user will see the view
as
> it works but should never see the DB tables or the text of the view.
> Just D.
>
>

MS SQL Pricing.

I'm at a junction where I need to choose a database. I really like the MS SQL DB but as far as I can tell its VERY VERY expensive to run as your webdatabase. Of course, you can choose the MSDE database, but with forumsoftware, article software, link software, and the like - the concurrent connection limitation seems like a unncessary showstopper.

I had hoped that the Windows 2003 webedition would have included som kind of "MSSQL bundle" that I could have purchased for my non-profit initiatives. But no dice.

So what should I choose? MySql 4? or does anyone know that Microsoft will have some MSSQL pricing changes just around the corner?If history is any indication, pricing will go up ;-) There isn't a new version of SQL Server out for awhile yet. I'm not sure what the limitations are on the Small Business Server package, if that's even still around. That might be one way to go.

I agree SQL Server is expensive for a small shop because if you use it as a web backend, you pretty much have to buy the per processor license. and it isn't cheap. still if you want SQL Server features, you have to pay the cost. Oracle is even worse. Another option for you is to outsource your site (host it elsewhere). There are a number of hosts that offer SQL Server as an option that are fairly reasonable, see the ASP.NET ISPs forum for some suggestions.

cs|||Yup, it really isn't practical for a small shop to use SQL Server as a backend. MS doesn't come right out and say it, but if you read between the lines a per processor is really the only viable way to licenses SQL Server for a web app. If anyone knows of any wording in the faq to back this up please post it or link to it. Reading thru the faqs etc... on how to licenses SQL server is about as pleasurable as banging your head against a meat grinder.

MySQL might be the way to go. Heck, it is probably becoming a valuable skill to have anyway. But, if you do want SQL Server, just buy it now and then take advantage of upgrade pricing when the next version comes out.|||::Yup, it really isn't practical for a small shop to use SQL Server as a backend.

Why? I know LARGE shops running happily on MSDE. Frankly, the limitations in MSDE are not really a lot:

* 2Gb per database. Now, unless you store videos in the database, 2Gb is a LOT - even for a CMS this is quite an amount.
* 5 parallel queries. Read the fineprint. Now, this is quite a lot, too. With smart programming, intellitgent use of output caching and all the nifts things you should do anyway to keep your processor usage down, you can probably max out a dual processor system with this limit.

The small shop does really not need more. And IF he needs more, SQL Server is not expensive at all.

::MySQL might be the way to go.

Yes, unless you need - a databae. The limitations of MySQL are a little harsh at the moment.

::Heck, it is probably becoming a valuable skill to have anyway

I know a lot of people who value MySQL very high. NONE of them is anyone I would trust with more than a "Select * from table", knowledge wise, when I want database work to be done. MySQL is extreme in it's limitations.|||Read, Thona, Read

>> Yup, it really isn't practical for a small shop to use SQL Server as a backend.

(read: It's too expensive)

you reply: Why? I know LARGE shops running happily on MSDE.

??

makes no sense at all.|||MSDE != SQL Server, although I agree it is a valid alternative for some situations. But the original question was regarding SQL Server. There are some limitations on how you can use MSDE and be within licensing compliance.

from http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp

Q. Can I use MSDE as a database for Web applications?

A. MSDE is an ideal solution for low-end Web applications. The following products and services enable you to redistribute MSDE as a database server for Web applications:

ASP.NET Web Matrix*
MSDN Universal, Enterprise, and Professional subscriptions
Office XP Developer Edition
SQL Server 2000 Developer, Standard, and Enterprise Editions
Visual Studio .NET Architect, Developer, and Professional Editions
Visual FoxPro 7.0 or 8.0
* When obtained by downloading ASP.NET Web Matrix, MSDE is provided only for use in conjunction with an application developed by using ASP.NET Web Matrix.

cs

MS SQL Jobs

Hi SQL Guru's

I am trying to run a job on Multiple SQL Servers in a domain.I am setting the job on my system,but the Radio button "Target Multiple Servers" is disabled.How do I enable the radio button "Target Multiple Servers".
Please let me know if this is possible.

Best Regards

SK.you have to ensure that your machine is a master and that you have
registered servers to be targets.

Right click sql server agent -- Multi Server Administration -- Make this a master.
During this process you will be asked to create a MSX operator. and to enlist targets. the targets will need to be pre-registered with your master's instance and then define the jobs on the master and then you will be able to target multiple servers.

understand that this process is designed to return all job history to the master so you can check the progress of job operations from one place. however, just as with the highlander, there can be only one.... meaning that a target cannot be a master for other servers.

:confused: and dont forget to check books online,
BOOKS ONLINE {Multiserver Administration}

MS SQL export / import data

Hi there,

I need to dump some data from a db by using MS Query. I noticed couple of issues during my attempts to do so. However I tried to run a query like:

SELECT table.column
INTO OUTFILE '/tmp/result.txt'
FROM table

which generated an error message:
Didn't expect "OUTFILE" after the SELECT column list.

Next I tried was:

SELECT table.column
FROM table
INTO OUTFILE '/tmp/result.txt'

generated another error:
Syntax error in FROM clause.

I also tried to define not only relative path to te result file but absolute path as well but it didn't help me a lot :-(
Could anybody help me what is theright syntx of this statement or is there some special way of MS Query to dump or export or write rows from the database into a file ?

Every suggestion will be higky appreciated

Tanks in advancewhy not try select col1name1, colname2, ... from tablename
then highlight the results, copy it and paste in a text editor eg notepad.
You can then save it and eventually open with excel.