I have received visual studio 2005 beta experience kit. My kit included a version of MS SQL-Server 2005 Developer Edition CTP ( Developer Edition printed on the surface of my DVD but I don't know it's true or not ? 
If it is how can I fix this problem?
Excuse me for my bad English writing!
thank you!
You should try posting this question to SQL Server Setup & Upgrade forum.
Thanks,
-Vineet Rao
Hello,
When I try to install SQL Server 2005 Standard Edition, Windows XP SP2, setup fails.
Please help!!!
This is log file:
..............................
Loaded DLL:
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\DbgHelp.dll
Version:
6.5.3.7
MSI (s) (98:E8) [12:19:07:890]: Leaked MSIHANDLE (6010) of type 790531 for thread 2260
MSI (s) (98:E8) [12:19:07:890]: Leaked MSIHANDLE (6009) of type 790540 for thread 2260
MSI (s) (98:E8) [12:19:07:890]: Leaked MSIHANDLE (6008) of type 790541 for thread 2260
MSI (s) (98:E8) [12:19:07:890]: Leaked MSIHANDLE (5973) of type 790541 for thread 2260
MSI (s) (98:E8) [12:19:07:890]: Leaked MSIHANDLE (5970) of type 790531 for thread 2260
MSI (s) (98:E8) [12:19:07:890]: Note: 1: 2769 2: Write_sqlLocalServers.D20239D7_E87C_40C9_9837_E70B8D4882C2 3: 5
Info 2769.The installer has encountered an unexpected error. The error code is 2769. Custom Action Write_sqlLocalServers.D20239D7_E87C_40C9_9837_E70B8D4882C2 did not close 5 MSIHANDLEs.
MSI (s) (98:2C) [12:19:07:890]: Machine policy value 'DisableRollback' is 0
MSI (s) (98:2C) [12:19:07:890]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2
Action ended 12:19:07: Write_sqlLocalServers.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 3.
MSI (s) (98:2C) [12:19:07:890]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2
MSI (s) (98:2C) [12:19:07:890]: No System Restore sequence number for this installation.
MSI (s) (98:2C) [12:19:07:890]: Unlocking Server
Action ended 12:19:07: INSTALL. Return value 3.
Property(S): ProductCode = {28B22773-100E-4AF2-A1C9-2F2EA8A35844}
Property(S): ProductLanguage = 1033
You did not say what version of XP you are running because you cannot install SQL Server 2005 Standard in XP Home, if you are running Media edition or Pro copy the content of the CDs/DVD into a folder in your C drive and run setup from your C drive. One more thing if you intend to install Reporting Services make sure IIS is running or the installer will skip it without telling you why. Hope this helps.
|||From the error message in the log, it appears that you have a setting on your machine which is preventing the systemstate backup to be rolled back. Check with your network administrator about disabling this setting.|||I have Windows XP professional. IIS is running. Installation from C is also failed.
May be, I uninstalled incorrectly beta-version of Visual studio 2005 and/or SQL Server 2005.
I uninstalled all components and then cleaned register, but it didn't help.
Thanks.
Gato.
|||
Please comment what setting "is preventing the systemstate backup to be rolled back" , where and how can I check that?
I work without network administrator 
Thanks,
Gato.
|||
Gato wrote:
I have Windows XP professional. IIS is running. Installation from C is also failed.
May be, I uninstalled incorrectly beta-version of Visual studio 2005 and/or SQL Server 2005.
I uninstalled all components and then cleaned register, but it didn't help.
Thanks.
Gato.
Lets start with some WinXP system restore to the last available restore point and copy the files to the C and install from C drive. And I just noticed you are not running the standard setup, because I know the bootstrap setup runs for a short while and terminates. The 2005 installer is very easy I know because I had installed 2000 on all operating systems including 64bits except Vista and it was a pain but installing 2005 was a breeze. Keep me posted and pay attention to the installer don't answer questions not relevant to you.
I have a strange problem while using sqlceconnection object. I'm using Sql Server 2005 Compact edition. While I'm trying to open the connection, an exception with blank message is raised, But if I open Query analyser on my windows ce 5.0 device and try to run the application again, it works(connection is getting opened)...Anyone faced this issue before?
Any help is greatly apreciated
I have a strange problem while using sqlceconnection object. I'm using Sql Server 2005 Compact edition. While I'm trying to open the connection, an exception with blank message is raised, But if I open Query analyser on my windows ce 5.0 device and try to run the application again, it works(connection is getting opened)...Anyone faced this issue before?
Any help is greatly apreciated
I'm using VS2005 with SP1
|||Out of memory? When do you open your connection in your app (early or later)?|||Hi,
Below is the code I'm using to open the connection.
Code Snippet
publicDataSet GetDataToPopulate(string sSql)
{
string sDataSource = ConfigurationSettings.AppSettings["db"].ToString();
SqlCeDataAdapter da = newSqlCeDataAdapter();
SqlCeCommand cmdSelect = newSqlCeCommand();
DataSet ds = newDataSet();
if(!System.IO.File.Exists(sDataSource))
throw(newApplicationException("Database not exists"));
SqlCeConnection cn=newSqlCeConnection("Data Source = " + sDataSource);
try
{
cn.Open();
cmdSelect.Connection = cn;
cmdSelect.CommandText = sSql;
cmdSelect.CommandType = CommandType.Text ;
da.SelectCommand = cmdSelect;
da.Fill(ds);
return ds;
}
catch(SqlCeException ex)
{
sError = ex.Message;
returnnull;
}
catch(Exception ex1)
{
sError = ex1.Message ;
returnnull;
}
finally
{
ds.Dispose();
ds.Dispose();
cmdSelect.Dispose();
if(cn.State == ConnectionState.Open )
cn.Close();
cn.Dispose();
}
}
|||You are creating a dataset. Is your table large, then the dataset will take a large amount of memory. In order to get the exact SQL CE error message, see this sample (getting ex.Message is not enough!) : http://msdn2.microsoft.com/en-us/library/ms174079.aspx|||I am having the identical problem. Does anyone know of a fix or work around?
In the code below, open throws a blank error. I have tested the code with and without tables in the referenced database. If the path to the database file is wrong I get a specific error so it’s not a path issue. Any ideas?
private SqlCeConnection loadDatabase(string Path)Thanks,
Matthew
|||The error now produced from this code from the posting above is as follows:
Error Code: 8007000E
Message :
Minor Err: 0
Source: SQL Server Compact Edition ADO.Net Data Provider
private SqlCeConnection loadDatabase(string Path)
{
SqlCeConnection temp_cn = null;
try
{
temp_cn = new SqlCeConnection("Data Source=" + Path + "");
temp_cn.Open();
temp_cn.Close();
}
catch (SqlCeException e)
{
ShowErrors(e);
}
return temp_cn;
}
// Error handling routine that generates an error message
public static void ShowErrors(SqlCeException e)
{
SqlCeErrorCollection errorCollection = e.Errors;
StringBuilder bld = new StringBuilder();
Exception inner = e.InnerException;
if (null != inner)
{
MessageBox.Show("Inner Exception: " + inner.ToString());
}
// Enumerate the errors to a message box.
foreach (SqlCeError err in errorCollection)
{
bld.Append("\n Error Code: " + err.HResult.ToString("X"));
bld.Append("\n Message : " + err.Message);
bld.Append("\n Minor Err.: " + err.NativeError);
bld.Append("\n Source : " + err.Source);
// Enumerate each numeric parameter for the error.
foreach (int numPar in err.NumericErrorParameters)
{
if (0 != numPar) bld.Append("\n Num. Par. : " + numPar);
}
// Enumerate each string parameter for the error.
foreach (string errPar in err.ErrorParameters)
{
if (String.Empty != errPar) bld.Append("\n Err. Par. : " + errPar);
}
MessageBox.Show(bld.ToString());
bld.Remove(0, bld.Length);
}
}
|||The error indicates an out of memory condition. Which device are you runnng on: Desktop, Pocket PC, Smartphone?I have a strange problem while using sqlceconnection object. I'm using Sql Server 2005 Compact edition. While I'm trying to open the connection, an exception with blank message is raised, But if I open Query analyser on my windows ce 5.0 device and try to run the application again, it works(connection is getting opened)...Anyone faced this issue before?
Any help is greatly apreciated
I have a strange problem while using sqlceconnection object. I'm using Sql Server 2005 Compact edition. While I'm trying to open the connection, an exception with blank message is raised, But if I open Query analyser on my windows ce 5.0 device and try to run the application again, it works(connection is getting opened)...Anyone faced this issue before?
Any help is greatly apreciated
I'm using VS2005 with SP1
|||Out of memory? When do you open your connection in your app (early or later)?|||Hi,
Below is the code I'm using to open the connection.
Code Snippet
public DataSet GetDataToPopulate(string sSql)
{
string sDataSource = ConfigurationSettings.AppSettings["db"].ToString();
SqlCeDataAdapter da = new SqlCeDataAdapter();
SqlCeCommand cmdSelect = new SqlCeCommand();
DataSet ds = new DataSet();
if(!System.IO.File.Exists(sDataSource))
throw(new ApplicationException("Database not exists"));
SqlCeConnection cn=new SqlCeConnection("Data Source = " + sDataSource);
try
{
cn.Open();
cmdSelect.Connection = cn;
cmdSelect.CommandText = sSql;
cmdSelect.CommandType = CommandType.Text ;
da.SelectCommand = cmdSelect;
da.Fill(ds);
return ds;
}
catch(SqlCeException ex)
{
sError = ex.Message;
return null;
}
catch(Exception ex1)
{
sError = ex1.Message ;
return null;
}
finally
{
ds.Dispose();
ds.Dispose();
cmdSelect.Dispose();
if(cn.State == ConnectionState.Open )
cn.Close();
cn.Dispose();
}
}
|||You are creating a dataset. Is your table large, then the dataset will take a large amount of memory. In order to get the exact SQL CE error message, see this sample (getting ex.Message is not enough!) : http://msdn2.microsoft.com/en-us/library/ms174079.aspx|||I am having the identical problem. Does anyone know of a fix or work around?
In the code below, open throws a blank error. I have tested the code with and without tables in the referenced database. If the path to the database file is wrong I get a specific error so it’s not a path issue. Any ideas?
private SqlCeConnection loadDatabase(string Path)Thanks,
Matthew
|||The error now produced from this code from the posting above is as follows:
Error Code: 8007000E
Message :
Minor Err: 0
Source: SQL Server Compact Edition ADO.Net Data Provider
private SqlCeConnection loadDatabase(string Path)
{
SqlCeConnection temp_cn = null;
try
{
temp_cn = new SqlCeConnection("Data Source=" + Path + "");
temp_cn.Open();
temp_cn.Close();
}
catch (SqlCeException e)
{
ShowErrors(e);
}
return temp_cn;
}
// Error handling routine that generates an error message
public static void ShowErrors(SqlCeException e)
{
SqlCeErrorCollection errorCollection = e.Errors;
StringBuilder bld = new StringBuilder();
Exception inner = e.InnerException;
if (null != inner)
{
MessageBox.Show("Inner Exception: " + inner.ToString());
}
// Enumerate the errors to a message box.
foreach (SqlCeError err in errorCollection)
{
bld.Append("\n Error Code: " + err.HResult.ToString("X"));
bld.Append("\n Message : " + err.Message);
bld.Append("\n Minor Err.: " + err.NativeError);
bld.Append("\n Source : " + err.Source);
// Enumerate each numeric parameter for the error.
foreach (int numPar in err.NumericErrorParameters)
{
if (0 != numPar) bld.Append("\n Num. Par. : " + numPar);
}
// Enumerate each string parameter for the error.
foreach (string errPar in err.ErrorParameters)
{
if (String.Empty != errPar) bld.Append("\n Err. Par. : " + errPar);
}
MessageBox.Show(bld.ToString());
bld.Remove(0, bld.Length);
}
}
|||The error indicates an out of memory condition. Which device are you runnng on: Desktop, Pocket PC, Smartphone?hello everybody
I want to ask for your help in an issue i am having with SQL Server 2005 Developer Edition . here is the issue:
We have 2 servers called: c10 and cweb. In both, we manually installed SQL server 2005 Dev Edition with no problems.
I created a linked server on c10 to access data on cweb. That is working fine with no problem when executing Select or Insert T-SQL statments like these ones from c10:
select * from cweb.DBNAME.dbo.TableNAME
Or
insert into cweb.DBNAME.dbo.TableNAME (f1, f2, f3)
select f1,f2,f3 from c10.DBNAME.dbo.TableNAME
All works fine up to here. But then there is a new server we setup called c7. This time we created an image of c10 and restore that image on this new server c7. That way, we didnt need to install all software needed in this new server. All software seemed to work ok..but then SQL server 2005 on that new server started failing when doing SELECT t-sql statements.
So Now if i am on c7 and i try to execute this: SELECT * from C7.DNAME.dbo.TableName, it fails
C7 in this case is the local server and it should work. however the error it gives me is that :"linked server not recognize"...it shouldnt need a linked server since it is trying to access the local server. Even with that, i tried to create a linked server to the own local server and now that Select t-sql isntruction worked with no problem..But now here is the othe issue i am having: INSERT t-sql statements are not working. When doing this:
insert into c7.DBNAME.dbo.TableNAME (f1, f2, f3)
select f1,f2,f3 from c7.DBNAME.dbo.TableNAME2
It fails with the following 2 error messages:
"OLE DB provider "SQLNCLI" for linked server "c7" returned message "Multiple-Step OLE DB operation generated errors. Check each OLE DB status, if available. No work was done
The OLE DB provider SQLNCLI for linked server citrix7 could not insert into table c7.DBNAMe.dbo.TableNAme because of column intID. the data value violated the integrity constraints for the column."
I checked that the SELECT part of the INSERT T-sql statement is not retrieving any invalid data for column intID.
I tried restoring the BD on c10 server and tried the same INSERT statement and it worked ok..which mean the data to be inserted is valid.
So i think it is related to some mis-configuration on the linked server or something in SQL server got broken when restoring c10 server image into the new c7 server
So in summary the problem is this:
1. i can not make SELECT T-sql statements using fully qualified names on the local sql server without having a linked server to the local server (which is strange)
2. I can not make INSERT T-sql statements in the local server. This errors happens when doing it
"OLE DB provider "SQLNCLI" for linked server "c7" returned message "Multiple-Step OLE DB operation generated errors. Check each OLE DB status, if available. No work was done
The OLE DB provider SQLNCLI for linked server citrix7 could not insert into table c7.DBNAMe.dbo.TableNAme because of column intID. the data value violated the integrity constraints for the column."
I have been searching thru google and forums but havent found any solutions yet.
Hope you can help me with this..i guess my only option right now is just uninstall and re-install sql server..but maybe there is any other solution to this_?
thanks a lot
Helkyn
This is a Transact-SQL question, not an SSIS question. Moving there...After applying the changes mentioned in KB 914277 to allow remote connections, while working in Visual Studio 2005, I'm now getting an error with the number 26: Error locating server/Instance specified...
Sure wish I knew what remote means in this scenario, as there is nothing "remote" about my installation. I only have 1 computer, the one i'm working on, where SQL Server and Visual Studio are installed, and no networks involved, so what is remote?
Any help would be appreciated!!
If the sql server you are trying to connect to and the app you are running are on the same physical machine then you do not need to config remote connections.
Can you check if the SQL Server is still running via the services.msc or config manager first of all.
|||If there is a way of telling SQL Server that I don't need any remote connection, I'd be more than happy to use it.
However I don't know how to do that... therefore I got the error-message about the remote connection.
How do I tell SQL Server there is no need for a remote connection?
Thanx!!
|||Use the surface area config tool|||And then...
Check what, click what, do what?
I've only been able to install SQL Server, with a lot of coaching from this forum, I've never used it, and have no idea what makes it or any of it's utilities tick...
I'm thankful for any advice I've been given, but I have no idea what to do with the Surface Area tool, when I get there...
|||Hello Layne - I got your e-mail about still not being able to connect. Without more information, this will be hard for everyone to help you with. But before I give you some more pointers, you should know about a couple of things.
First, this isn't the primary mechanism for support for Microsoft products. Everyone here is happy to help out where we can, but it's a free site where Microsoft and other database folks will try and help you. We'll do what we can to help you, but there are no guarantees. Microsoft hosts these sites (again, at no cost to you) but this isn't the primary method they support their products. If you need immediate assistance you can check out several support options at http://www.microsoft.com/support.
I also think the comments in your e-mail to me about "all of us going back to India" isn't very polite. If you're asking for help (for free), you may want to be complimentary rather than derogatory. It will get you more answers faster to be polite to others.
The best place for you to look for what you're asking is:
http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx
It's on Express, but will help you with your edition as well.
|||If the problem is just remote connection is not allowed on the remote server read and check whether the remote server is configured as in the following article http://www.kodyaz.com/content/SQLServerdoesnotallowremoteconnections.aspx but it seems that you are hitting another problem
After applying the changes mentioned in KB 914277 to allow remote connections, while working in Visual Studio 2005, I'm now getting an error with the number 26: Error locating server/Instance specified...
Sure wish I knew what remote means in this scenario, as there is nothing "remote" about my installation. I only have 1 computer, the one i'm working on, where SQL Server and Visual Studio are installed, and no networks involved, so what is remote?
Any help would be appreciated!!
If the sql server you are trying to connect to and the app you are running are on the same physical machine then you do not need to config remote connections.
Can you check if the SQL Server is still running via the services.msc or config manager first of all.
|||If there is a way of telling SQL Server that I don't need any remote connection, I'd be more than happy to use it.
However I don't know how to do that... therefore I got the error-message about the remote connection.
How do I tell SQL Server there is no need for a remote connection?
Thanx!!
|||Use the surface area config tool|||And then...
Check what, click what, do what?
I've only been able to install SQL Server, with a lot of coaching from this forum, I've never used it, and have no idea what makes it or any of it's utilities tick...
I'm thankful for any advice I've been given, but I have no idea what to do with the Surface Area tool, when I get there...
|||Hello Layne - I got your e-mail about still not being able to connect. Without more information, this will be hard for everyone to help you with. But before I give you some more pointers, you should know about a couple of things.
First, this isn't the primary mechanism for support for Microsoft products. Everyone here is happy to help out where we can, but it's a free site where Microsoft and other database folks will try and help you. We'll do what we can to help you, but there are no guarantees. Microsoft hosts these sites (again, at no cost to you) but this isn't the primary method they support their products. If you need immediate assistance you can check out several support options at http://www.microsoft.com/support.
I also think the comments in your e-mail to me about "all of us going back to India" isn't very polite. If you're asking for help (for free), you may want to be complimentary rather than derogatory. It will get you more answers faster to be polite to others.
The best place for you to look for what you're asking is:
http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx
It's on Express, but will help you with your edition as well.
|||If the problem is just remote connection is not allowed on the remote server read and check whether the remote server is configured as in the following article http://www.kodyaz.com/content/SQLServerdoesnotallowremoteconnections.aspx but it seems that you are hitting another problem
