I installed Visual Studio .NET v.1.0 and the included MSDE version of
SQL Server. I have an additional copy of MS SQL Server 2000 Enterprise
Ed. on CD. I installed Microsoft Analysis Services from this CD on my
machine with MSDE SQL Server; it appeared to install cleanly.
I ran Analysis Manager from the Start menu under Windows XP Pro. The
local SQL Server showed red block indicating the server was not
running. I tried to connect, and got the following error message:
Unable to connect to the registry on the server (myserver_name), or you
are not a member of the OLAP Administrators group on this server.
Does anyone know the problem here? I was wondering whether I had to
install MS SQL Server enterprise ed. to use Analysis Server with it,
rather than more limited MSDE version of SQL Server ?!
Thanks all.
Fred Z.
hi Fred,
silversw2000@.yahoo.com wrote:
> I installed Visual Studio .NET v.1.0 and the included MSDE version of
> SQL Server. I have an additional copy of MS SQL Server 2000 Enterprise
> Ed. on CD. I installed Microsoft Analysis Services from this CD on my
> machine with MSDE SQL Server; it appeared to install cleanly.
> I ran Analysis Manager from the Start menu under Windows XP Pro. The
> local SQL Server showed red block indicating the server was not
> running. I tried to connect, and got the following error message:
> Unable to connect to the registry on the server (myserver_name), or
> you are not a member of the OLAP Administrators group on this server.
> Does anyone know the problem here? I was wondering whether I had to
> install MS SQL Server enterprise ed. to use Analysis Server with it,
> rather than more limited MSDE version of SQL Server ?!
> Thanks all.
> Fred Z.
I do not think Analysis Service is supported on MSDE..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
Showing posts with label visual. Show all posts
Showing posts with label visual. Show all posts
Sunday, March 25, 2012
Analysis Server database stop responding...
Hi, everyone, I'm new in SSAS... Yesterday I mapped a new hierachy to a perspective and then the database died... I tried to connect to it in Visual Studio and open it in Management Studio, however, neither responsed, then the delay notification appeared... Database engine and analysis service are alright, the tables are quite small (less then 50MB).
Dose anyone have ideas about this? Thanks a lot.
The version of my SQL Server is 9.00.2047.00, runs on Windows 2003 Server SP1.
Suspect your data got corrupted somehow.
Try stopping Analysis Server. Delete files from the database folder in the Analysis Server data folder.
Then start the server again and try re-deploying the project again.
Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Ed:
Thanks for your reply. I think I've found the reason. This is not caused by my modifications on the SSAS db, one of our databases grew too fast and makes the server running slowly, our DBA has solved this problem.
regards,
Monday, March 19, 2012
An internal error occurred on the report server. See the error log
I've just installed SQL Reporting Services. I have a Report Project in
Visual Studio and added already existing reports. When I try to build the
solution, I get the following error for each report:
An internal error occurred on the report server. See the error log for more
details.
Looking in the Windows Event Viewer, there are no entries that correspond to
this. The most recent entry is an hour ago, even though I got this error
message two minutes ago.
Am I looking in the wrong place? Does anyone have any other suggestions as
to why this won't work?
BTW: I also tried to upload the report on the reportserver. When I try to
run a report from there, I get a similar error:
An internal error occurred on the report server. See the error log for more
details. (rsInternalError) Get Online Help
SELECT permission denied on object 'ExecutionCache', database
'ReportServerTempDB', owner 'dbo'. SELECT permission denied on object
'ExecutionCache', database 'ReportServerTempDB', owner 'dbo'. SELECT
permission denied on object 'SnapshotData', database 'ReportServerTempDB',
owner 'dbo'.
Thank you in advance,
MKFigured it out! I had already set the permissions for the ASPNET user in the
ReportServer table to allow RSExecRole... just had to do the same for the
ReportServerTempDB
"k89mmk" wrote:
> I've just installed SQL Reporting Services. I have a Report Project in
> Visual Studio and added already existing reports. When I try to build the
> solution, I get the following error for each report:
> An internal error occurred on the report server. See the error log for more
> details.
> Looking in the Windows Event Viewer, there are no entries that correspond to
> this. The most recent entry is an hour ago, even though I got this error
> message two minutes ago.
> Am I looking in the wrong place? Does anyone have any other suggestions as
> to why this won't work?
> BTW: I also tried to upload the report on the reportserver. When I try to
> run a report from there, I get a similar error:
> An internal error occurred on the report server. See the error log for more
> details. (rsInternalError) Get Online Help
> SELECT permission denied on object 'ExecutionCache', database
> 'ReportServerTempDB', owner 'dbo'. SELECT permission denied on object
> 'ExecutionCache', database 'ReportServerTempDB', owner 'dbo'. SELECT
> permission denied on object 'SnapshotData', database 'ReportServerTempDB',
> owner 'dbo'.
> Thank you in advance,
> MK|||k89mmk wrote:
> An internal error occurred on the report server. See the error log
> for more details. (rsInternalError) Get Online Help
> SELECT permission denied on object 'ExecutionCache', database
> 'ReportServerTempDB', owner 'dbo'. SELECT permission denied on object
> 'ExecutionCache', database 'ReportServerTempDB', owner 'dbo'. SELECT
> permission denied on object 'SnapshotData', database
> 'ReportServerTempDB', owner 'dbo'.
You will find the reporting-logs normally in:
C:\Programme\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles
Your error assumed that you use nt-authentification and your nt-account has
no sufficient rights on the ReportServer-DBs OR the account under wich the
reportenginge is running has no sufficient rights on his own dbs
regards
Frank
www.xax.de
Visual Studio and added already existing reports. When I try to build the
solution, I get the following error for each report:
An internal error occurred on the report server. See the error log for more
details.
Looking in the Windows Event Viewer, there are no entries that correspond to
this. The most recent entry is an hour ago, even though I got this error
message two minutes ago.
Am I looking in the wrong place? Does anyone have any other suggestions as
to why this won't work?
BTW: I also tried to upload the report on the reportserver. When I try to
run a report from there, I get a similar error:
An internal error occurred on the report server. See the error log for more
details. (rsInternalError) Get Online Help
SELECT permission denied on object 'ExecutionCache', database
'ReportServerTempDB', owner 'dbo'. SELECT permission denied on object
'ExecutionCache', database 'ReportServerTempDB', owner 'dbo'. SELECT
permission denied on object 'SnapshotData', database 'ReportServerTempDB',
owner 'dbo'.
Thank you in advance,
MKFigured it out! I had already set the permissions for the ASPNET user in the
ReportServer table to allow RSExecRole... just had to do the same for the
ReportServerTempDB
"k89mmk" wrote:
> I've just installed SQL Reporting Services. I have a Report Project in
> Visual Studio and added already existing reports. When I try to build the
> solution, I get the following error for each report:
> An internal error occurred on the report server. See the error log for more
> details.
> Looking in the Windows Event Viewer, there are no entries that correspond to
> this. The most recent entry is an hour ago, even though I got this error
> message two minutes ago.
> Am I looking in the wrong place? Does anyone have any other suggestions as
> to why this won't work?
> BTW: I also tried to upload the report on the reportserver. When I try to
> run a report from there, I get a similar error:
> An internal error occurred on the report server. See the error log for more
> details. (rsInternalError) Get Online Help
> SELECT permission denied on object 'ExecutionCache', database
> 'ReportServerTempDB', owner 'dbo'. SELECT permission denied on object
> 'ExecutionCache', database 'ReportServerTempDB', owner 'dbo'. SELECT
> permission denied on object 'SnapshotData', database 'ReportServerTempDB',
> owner 'dbo'.
> Thank you in advance,
> MK|||k89mmk wrote:
> An internal error occurred on the report server. See the error log
> for more details. (rsInternalError) Get Online Help
> SELECT permission denied on object 'ExecutionCache', database
> 'ReportServerTempDB', owner 'dbo'. SELECT permission denied on object
> 'ExecutionCache', database 'ReportServerTempDB', owner 'dbo'. SELECT
> permission denied on object 'SnapshotData', database
> 'ReportServerTempDB', owner 'dbo'.
You will find the reporting-logs normally in:
C:\Programme\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles
Your error assumed that you use nt-authentification and your nt-account has
no sufficient rights on the ReportServer-DBs OR the account under wich the
reportenginge is running has no sufficient rights on his own dbs
regards
Frank
www.xax.de
Sunday, March 11, 2012
An error occurred during the execution of the SQL file 'InstallCommon.sql'.
Hi,
I'm using Microsoft Visual Studio 2005 Beta 2.
I have created Personal Site using Project Template. 1st it started giving me error related to "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed."
Then i made changes in web.config under configuration "User Instance=True" to "User Instance=False".
Now it started giving me error as follows:
An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error number is 262 and the SqlException message is: CREATE DATABASE permission denied in database 'master'.
Creating the C__INETPUB_WWWROOT_SITE_APP_DATA_ASPNETDB database...
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
SQLExpress database file auto-creation error:
The connection string specifies a local SQL Server Express instance using a database location within the applications App_Data directory. The provider attempted to automatically create the application services database because the provider determined that the database does not exist. The following configuration requirements are necessary to successfully check for existence of the application services database and automatically create the application services database:
- If the applications App_Data directory does not already exist, the web server account must have read and write access to the applications directory. This is necessary because the web server account will automatically create the App_Data directory if it does not already exist. If the applications App_Data directory already exists, the web server account only requires read access to the applications App_Data directory. This is necessary because the web server account will attempt to verify that the SQL Server Express database already exists within the applications App_Data directory. Note that revoking read access on the App_Data directory from the web server account will prevent the provider from correctly determining if the SQL Server Express database already exists. This will cause an error when SQL Server Express attempts to create a duplicate of an already existing database. SQL Server Express must be installed on the machine. If the application services database does not already exist, the SQL Server Express service account must have read and write access to the applications App_Data directory. This is necessary because the SQL Server Express service account will create the application services database. The web server account used to connect to SQL Server Express must have rights to create a new database.
- When using the local web server(Cassini) installed with Visual Studio, the logged-in user needs the dbcreator privilege in the appropriate SQL Server Express instance. When using IIS, the process account needs the dbcreator privilege in the appropriate SQL Server Express instance. Only consider granting a process account dbcreator privilege on secure development machines. Do not grant the dbcreator privilege on production machines without fully investigating and understanding the security ramifications of running a production web server with the dbcreator privilege. The process account requiring dbcreator privilege varies depending on operating system platform and ASP.NET configuration settings: For IIS5, and IIS6 running in IIS5 isolation mode, the default web server account is the local ASPNET machine account. For IIS6 native mode, the default web server account is NETWORK SERVICE. If application impersonation is enabled, then the application impersonation account requires the dbcreator privilege. If an explicit account was specified for the web server process (either in the <processModel> element for IIS5 and IIS5 isolation mode, or the application pool account on IIS6), then the explicit account requires the dbcreator privilege.
Stack Trace:
[SqlExecutionException: An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error number is 262 and the SqlException message is: CREATE DATABASE permission denied in database 'master'. Creating the C__INETPUB_WWWROOT_SITE_APP_DATA_ASPNETDB database...] System.Web.Management.SqlServices.ExecuteFile(String file, String server, String database, String dbFileName, SqlConnection connection, Boolean sessionState, SessionStateType sessionStatetype) +783 System.Web.Management.SqlServices.SetupApplicationServices(String server, String user, String password, Boolean trusted, String connectionString, String database, String dbFileName, SqlFeatures features, Boolean install) +721 System.Web.DataAccess.SqlConnectionHelper.EnsureValidMdfFile(String fullFileName, String dataDir, String connectionString) +365 Wednesday, March 7, 2012
An attempt to attach an auto-named database for file failed
Hi
I have a problem when I want to open a page with the database record. This page is created in Visual Web Developer 2005 Express. When I try to open a page I get the following error message even though the connection between the database is ok:
An attempt to attach an auto-named database for file C:\Inetpub\wwwroot\membership\App_Data\aspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details:System.Data.SqlClient.SqlException: An attempt to attach an auto-named database for file C:\Inetpub\wwwroot\membership\App_Data\aspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
I have a computer with Windows XP Professional running IIS 5.1 and ASP.NET 2.0.
Also I have SQL Express on my machine.
Does any one know how to resolve it.
Thanks![Smile [:)]](http://pics.10026.com/?src=/emoticons/emotion-1.gif)
Here is the entire error message that I am getting:
Server Error in '/membership' Application.
An attempt to attach an auto-named database for file C:\Inetpub\wwwroot\membership\App_Data\aspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details:System.Data.SqlClient.SqlException: An attempt to attach an auto-named database for file C:\Inetpub\wwwroot\membership\App_Data\aspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.Stack Trace:
[SqlException (0x80131904): An attempt to attach an auto-named database for file C:\Inetpub\wwwroot\membership\App_Data\aspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.] System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +437 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +84 System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +197 System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat(String username, Boolean updateLastLoginActivityDate, Int32& status, String& password, Int32& passwordFormat, String& passwordSalt, Int32& failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount, Boolean& isApproved, DateTime& lastLoginDate, DateTime& lastActivityDate) +1121 System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat) +105 System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved) +42 System.Web.Security.SqlMembershipProvider.ValidateUser(String username, String password) +83 System.Web.UI.WebControls.Login.OnAuthenticate(AuthenticateEventArgs e) +160 System.Web.UI.WebControls.Login.AttemptLogin() +105 System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +99 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35 System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +163 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42
|||This is what I found in the event viewer:
Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date: 1/24/2006
Time: 5:17:15 PM
User: N/A
Computer: DEVELOMPMENT-CO
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 1/24/2006 5:17:15 PM
Event time (UTC): 1/24/2006 10:17:15 PM
Event ID: 29652843fd234fc6a5a00bd4f9652894
Event sequence: 4
Event occurrence: 3
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/ROOT/membership-7-127826143653860928
Trust level: Full
Application Virtual Path: /membership
Application Path: C:\Inetpub\wwwroot\membership\
Machine name: DEVELOMPMENT-CO
Process information:
Process ID: 2724
Process name: aspnet_wp.exe
Account name: DEVELOMPMENT-CO\ASPNET
Exception information:
Exception type: SqlException
Exception message: An attempt to attach an auto-named database for file C:\Inetpub\wwwroot\membership\App_Data\aspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
Request information:
Request URL:http://localhost/membership/Login.aspx
Request path: /membership/Login.aspx
User host address: 127.0.0.1
User:
Is authenticated: False
Authentication Type:
Thread account name: DEVELOMPMENT-CO\ASPNET
Thread information:
Thread ID: 1
Thread account name: DEVELOMPMENT-CO\ASPNET
Is impersonating: False
Stack trace: at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate)
at System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation)
at System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat(String username, Boolean updateLastLoginActivityDate, Int32& status, String& password, Int32& passwordFormat, String& passwordSalt, Int32& failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount, Boolean& isApproved, DateTime& lastLoginDate, DateTime& lastActivityDate)
at System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat)
at System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved)
at System.Web.Security.SqlMembershipProvider.ValidateUser(String username, String password)
at System.Web.UI.WebControls.Login.OnAuthenticate(AuthenticateEventArgs e)
at System.Web.UI.WebControls.Login.AttemptLogin()
at System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e)
at System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
at System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Custom event details:
For more information, see Help and Support Center athttp://go.microsoft.com/fwlink/events.asp.
This is the connection string:
<connectionStrings>
<addname="Membership"connectionString="Data Source=.\SQLEXPRESS;Integrated Security=True;User Instance=True;AttachDbFilename=|DataDirectory|aspnetdb.mdf;"
providerName="System.Data.SqlClient" />
</connectionStrings>
Thanks for any responses.
|||More information about this error. My web site works fine when I run it on this built in Asp.net Developer Server that comes with Visual Web Developer. I don't know why it doesn't work on my IIS 5.1 Server.
Any suggestions?
|||Hi,
The following URL has some explainations and things to try with this error
http://forums.microsoft.com/msdn/showpost.aspx?postid=98346&siteid=1
Hope that helps,
Lan
Monday, February 13, 2012
Am i going the right way about this
Hi,
Im building an application in vb.net 05 and mobile sql. When i added the mobile database in visual studio it added a Dataset object in the object viewer.
Now my question is should i add table adapters to this and do my selects inserts updates and deletes using this, or should i us the sqlceclient class connect to the db use a command object ect and do my operations?
I need it to be as fast as possible and 100 reliable.
Can anyone give me a clue as to the best way forward?
Trev
The automatic creating of bindingsource and datasource datasets is a convenience in VS2005 and you can certainly do most of your interaction with SQL Mobile using this approach. If you want finer-grained control over your interaction with SQL Mobile (for performance tuning for example), then I wouldn't use the auto-generated bindings and instead use SqlCeResultSet, SqlCeDataReader, and SqlCeCommands in TableDirect mode to perform your database operations when possible.
Darren
Always SQL Server 8.x from Management Studio
Greetings,
I originally have had SQL 2k SP3 installed before installing Visual Studio
2005 and SQL Server 2005. Anyway, that was a while ago. Now, for the first
time in a blue moon I have the need to be doing some SQL Server 2005 stuff
on my machine and the only server that SQL Server Management Studio finds or
connects to on this box is version 8.0.760. I can swear I had set up a 2k5
database in the past and did some work with it. I have installed SQL 2k5
Developer Edition.
My main question is, how do I connect to the 2k5 database, and if need be,
how do I add one so I can connect to it? This should be simple but it seems
not.
Thanks,
ShawnProbably you still have your SQL Server 2000 instance installed, and if you
worked with a SQL Server 2005 instance before on the same computer, most
likely this is a named instance.
Run SQL Server 2000 Service Manager and click the Server list to see the
installed instances (I can even see SQL Server 2005 instances there).
Run SQL Server 2005 Configuration Manager and look into SQL Server 2005
Services.
Hope this helps,
Ben Nevarez, MCDBA, OCP
Database Administrator
"Shawn B." wrote:
> Greetings,
> I originally have had SQL 2k SP3 installed before installing Visual Studio
> 2005 and SQL Server 2005. Anyway, that was a while ago. Now, for the fir
st
> time in a blue moon I have the need to be doing some SQL Server 2005 stuff
> on my machine and the only server that SQL Server Management Studio finds
or
> connects to on this box is version 8.0.760. I can swear I had set up a 2k
5
> database in the past and did some work with it. I have installed SQL 2k5
> Developer Edition.
> My main question is, how do I connect to the 2k5 database, and if need be,
> how do I add one so I can connect to it? This should be simple but it see
ms
> not.
>
> Thanks,
> Shawn
>
>|||> Probably you still have your SQL Server 2000 instance installed, and if
> you
> worked with a SQL Server 2005 instance before on the same computer, most
> likely this is a named instance.
> Run SQL Server 2000 Service Manager and click the Server list to see the
> installed instances (I can even see SQL Server 2005 instances there).
> Run SQL Server 2005 Configuration Manager and look into SQL Server 2005
> Services.
>
It does not show any SQL Server 2005 instances. Only the 2000 instance on
this machine and the 2000 instance on another machien. If it isn't showing
any 2005 instances running, how do I start it up? When I run SQL Server
2005 config man. everything seems as if 2005 is okay.
Thanks,
Shawn|||Try SQL Server Configuration Manager and select SQL Server 2005 Services.
Then look for the lines showing 'Service Type' as 'SQL Server'. There you
will see the instance name on the 'Name' column and you could check 'State'
to see if the instance is running or stopped.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Shawn B." wrote:
> It does not show any SQL Server 2005 instances. Only the 2000 instance on
> this machine and the 2000 instance on another machien. If it isn't showin
g
> any 2005 instances running, how do I start it up? When I run SQL Server
> 2005 config man. everything seems as if 2005 is okay.
>
> Thanks,
> Shawn
>
>|||> Try SQL Server Configuration Manager and select SQL Server 2005 Services.
> Then look for the lines showing 'Service Type' as 'SQL Server'. There you
> will see the instance name on the 'Name' column and you could check
> 'State'
> to see if the instance is running or stopped.
Well, there's my problem... I do not have "SQL Server" but I have a crap
load of others. How do I get the "SQL Server" service to appear? Should I
reinstall sql 2k5?
Thanks,
Shawn|||If 'SQL Server' is not listed on the 'Service Type' column then you do not
have an instance of SQL Server 2005. You could install a new one.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Shawn B." wrote:
> Well, there's my problem... I do not have "SQL Server" but I have a crap
> load of others. How do I get the "SQL Server" service to appear? Should
I
> reinstall sql 2k5?
>
> Thanks,
> Shawn
>
>|||> If 'SQL Server' is not listed on the 'Service Type' column then you do not
> have an instance of SQL Server 2005. You could install a new one.
How? Do I pop in the SQL Server 2005 (Server) disk? (as opposed to the
tools disk?). I've been spending hours and endless Google searches to
answer that very question and the answer is not clear (unless I'm using SQL
Express, which I'm not).
Thanks,
Shawn|||Hi Shawn,
Yes, install a new instance from your SQL Server 2005 media (in my case it
is SQL Server 2005 X Edition Disk 1'. Run setup and make sure you select 'SQ
L
Server Database Services' on the 'Components to Install' window.
If you already have a SQL Server 2000 default instance you can install a new
named instance for SQL Server 2005.
Installing SQL Server 2005 Service Pack 1 is a good idea too.
Hope this helps,
Ben Nevarez, MCDBA, OCP
Database Administrator
"Shawn B." wrote:
> How? Do I pop in the SQL Server 2005 (Server) disk? (as opposed to the
> tools disk?). I've been spending hours and endless Google searches to
> answer that very question and the answer is not clear (unless I'm using SQ
L
> Express, which I'm not).
>
> Thanks,
> Shawn
>
>|||> Yes, install a new instance from your SQL Server 2005 media (in my case it
> is SQL Server 2005 X Edition Disk 1'. Run setup and make sure you select
> 'SQL
> Server Database Services' on the 'Components to Install' window.
> If you already have a SQL Server 2000 default instance you can install a
> new
> named instance for SQL Server 2005.
> Installing SQL Server 2005 Service Pack 1 is a good idea too.
Done. That's all it was.
Thanks,
Shawn
I originally have had SQL 2k SP3 installed before installing Visual Studio
2005 and SQL Server 2005. Anyway, that was a while ago. Now, for the first
time in a blue moon I have the need to be doing some SQL Server 2005 stuff
on my machine and the only server that SQL Server Management Studio finds or
connects to on this box is version 8.0.760. I can swear I had set up a 2k5
database in the past and did some work with it. I have installed SQL 2k5
Developer Edition.
My main question is, how do I connect to the 2k5 database, and if need be,
how do I add one so I can connect to it? This should be simple but it seems
not.
Thanks,
ShawnProbably you still have your SQL Server 2000 instance installed, and if you
worked with a SQL Server 2005 instance before on the same computer, most
likely this is a named instance.
Run SQL Server 2000 Service Manager and click the Server list to see the
installed instances (I can even see SQL Server 2005 instances there).
Run SQL Server 2005 Configuration Manager and look into SQL Server 2005
Services.
Hope this helps,
Ben Nevarez, MCDBA, OCP
Database Administrator
"Shawn B." wrote:
> Greetings,
> I originally have had SQL 2k SP3 installed before installing Visual Studio
> 2005 and SQL Server 2005. Anyway, that was a while ago. Now, for the fir
st
> time in a blue moon I have the need to be doing some SQL Server 2005 stuff
> on my machine and the only server that SQL Server Management Studio finds
or
> connects to on this box is version 8.0.760. I can swear I had set up a 2k
5
> database in the past and did some work with it. I have installed SQL 2k5
> Developer Edition.
> My main question is, how do I connect to the 2k5 database, and if need be,
> how do I add one so I can connect to it? This should be simple but it see
ms
> not.
>
> Thanks,
> Shawn
>
>|||> Probably you still have your SQL Server 2000 instance installed, and if
> you
> worked with a SQL Server 2005 instance before on the same computer, most
> likely this is a named instance.
> Run SQL Server 2000 Service Manager and click the Server list to see the
> installed instances (I can even see SQL Server 2005 instances there).
> Run SQL Server 2005 Configuration Manager and look into SQL Server 2005
> Services.
>
It does not show any SQL Server 2005 instances. Only the 2000 instance on
this machine and the 2000 instance on another machien. If it isn't showing
any 2005 instances running, how do I start it up? When I run SQL Server
2005 config man. everything seems as if 2005 is okay.
Thanks,
Shawn|||Try SQL Server Configuration Manager and select SQL Server 2005 Services.
Then look for the lines showing 'Service Type' as 'SQL Server'. There you
will see the instance name on the 'Name' column and you could check 'State'
to see if the instance is running or stopped.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Shawn B." wrote:
> It does not show any SQL Server 2005 instances. Only the 2000 instance on
> this machine and the 2000 instance on another machien. If it isn't showin
g
> any 2005 instances running, how do I start it up? When I run SQL Server
> 2005 config man. everything seems as if 2005 is okay.
>
> Thanks,
> Shawn
>
>|||> Try SQL Server Configuration Manager and select SQL Server 2005 Services.
> Then look for the lines showing 'Service Type' as 'SQL Server'. There you
> will see the instance name on the 'Name' column and you could check
> 'State'
> to see if the instance is running or stopped.
Well, there's my problem... I do not have "SQL Server" but I have a crap
load of others. How do I get the "SQL Server" service to appear? Should I
reinstall sql 2k5?
Thanks,
Shawn|||If 'SQL Server' is not listed on the 'Service Type' column then you do not
have an instance of SQL Server 2005. You could install a new one.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Shawn B." wrote:
> Well, there's my problem... I do not have "SQL Server" but I have a crap
> load of others. How do I get the "SQL Server" service to appear? Should
I
> reinstall sql 2k5?
>
> Thanks,
> Shawn
>
>|||> If 'SQL Server' is not listed on the 'Service Type' column then you do not
> have an instance of SQL Server 2005. You could install a new one.
How? Do I pop in the SQL Server 2005 (Server) disk? (as opposed to the
tools disk?). I've been spending hours and endless Google searches to
answer that very question and the answer is not clear (unless I'm using SQL
Express, which I'm not).
Thanks,
Shawn|||Hi Shawn,
Yes, install a new instance from your SQL Server 2005 media (in my case it
is SQL Server 2005 X Edition Disk 1'. Run setup and make sure you select 'SQ
L
Server Database Services' on the 'Components to Install' window.
If you already have a SQL Server 2000 default instance you can install a new
named instance for SQL Server 2005.
Installing SQL Server 2005 Service Pack 1 is a good idea too.
Hope this helps,
Ben Nevarez, MCDBA, OCP
Database Administrator
"Shawn B." wrote:
> How? Do I pop in the SQL Server 2005 (Server) disk? (as opposed to the
> tools disk?). I've been spending hours and endless Google searches to
> answer that very question and the answer is not clear (unless I'm using SQ
L
> Express, which I'm not).
>
> Thanks,
> Shawn
>
>|||> Yes, install a new instance from your SQL Server 2005 media (in my case it
> is SQL Server 2005 X Edition Disk 1'. Run setup and make sure you select
> 'SQL
> Server Database Services' on the 'Components to Install' window.
> If you already have a SQL Server 2000 default instance you can install a
> new
> named instance for SQL Server 2005.
> Installing SQL Server 2005 Service Pack 1 is a good idea too.
Done. That's all it was.
Thanks,
Shawn
Always SQL Server 8.x from Management Studio
Greetings,
I originally have had SQL 2k SP3 installed before installing Visual Studio
2005 and SQL Server 2005. Anyway, that was a while ago. Now, for the first
time in a blue moon I have the need to be doing some SQL Server 2005 stuff
on my machine and the only server that SQL Server Management Studio finds or
connects to on this box is version 8.0.760. I can swear I had set up a 2k5
database in the past and did some work with it. I have installed SQL 2k5
Developer Edition.
My main question is, how do I connect to the 2k5 database, and if need be,
how do I add one so I can connect to it? This should be simple but it seems
not.
Thanks,
ShawnProbably you still have your SQL Server 2000 instance installed, and if you
worked with a SQL Server 2005 instance before on the same computer, most
likely this is a named instance.
Run SQL Server 2000 Service Manager and click the Server list to see the
installed instances (I can even see SQL Server 2005 instances there).
Run SQL Server 2005 Configuration Manager and look into SQL Server 2005
Services.
Hope this helps,
Ben Nevarez, MCDBA, OCP
Database Administrator
"Shawn B." wrote:
> Greetings,
> I originally have had SQL 2k SP3 installed before installing Visual Studio
> 2005 and SQL Server 2005. Anyway, that was a while ago. Now, for the first
> time in a blue moon I have the need to be doing some SQL Server 2005 stuff
> on my machine and the only server that SQL Server Management Studio finds or
> connects to on this box is version 8.0.760. I can swear I had set up a 2k5
> database in the past and did some work with it. I have installed SQL 2k5
> Developer Edition.
> My main question is, how do I connect to the 2k5 database, and if need be,
> how do I add one so I can connect to it? This should be simple but it seems
> not.
>
> Thanks,
> Shawn
>
>|||> Probably you still have your SQL Server 2000 instance installed, and if
> you
> worked with a SQL Server 2005 instance before on the same computer, most
> likely this is a named instance.
> Run SQL Server 2000 Service Manager and click the Server list to see the
> installed instances (I can even see SQL Server 2005 instances there).
> Run SQL Server 2005 Configuration Manager and look into SQL Server 2005
> Services.
>
It does not show any SQL Server 2005 instances. Only the 2000 instance on
this machine and the 2000 instance on another machien. If it isn't showing
any 2005 instances running, how do I start it up? When I run SQL Server
2005 config man. everything seems as if 2005 is okay.
Thanks,
Shawn|||Try SQL Server Configuration Manager and select SQL Server 2005 Services.
Then look for the lines showing 'Service Type' as 'SQL Server'. There you
will see the instance name on the 'Name' column and you could check 'State'
to see if the instance is running or stopped.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Shawn B." wrote:
> > Probably you still have your SQL Server 2000 instance installed, and if
> > you
> > worked with a SQL Server 2005 instance before on the same computer, most
> > likely this is a named instance.
> >
> > Run SQL Server 2000 Service Manager and click the Server list to see the
> > installed instances (I can even see SQL Server 2005 instances there).
> >
> > Run SQL Server 2005 Configuration Manager and look into SQL Server 2005
> > Services.
> >
> It does not show any SQL Server 2005 instances. Only the 2000 instance on
> this machine and the 2000 instance on another machien. If it isn't showing
> any 2005 instances running, how do I start it up? When I run SQL Server
> 2005 config man. everything seems as if 2005 is okay.
>
> Thanks,
> Shawn
>
>|||> Try SQL Server Configuration Manager and select SQL Server 2005 Services.
> Then look for the lines showing 'Service Type' as 'SQL Server'. There you
> will see the instance name on the 'Name' column and you could check
> 'State'
> to see if the instance is running or stopped.
Well, there's my problem... I do not have "SQL Server" but I have a crap
load of others. How do I get the "SQL Server" service to appear? Should I
reinstall sql 2k5?
Thanks,
Shawn|||If 'SQL Server' is not listed on the 'Service Type' column then you do not
have an instance of SQL Server 2005. You could install a new one.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Shawn B." wrote:
> > Try SQL Server Configuration Manager and select SQL Server 2005 Services.
> > Then look for the lines showing 'Service Type' as 'SQL Server'. There you
> > will see the instance name on the 'Name' column and you could check
> > 'State'
> > to see if the instance is running or stopped.
> Well, there's my problem... I do not have "SQL Server" but I have a crap
> load of others. How do I get the "SQL Server" service to appear? Should I
> reinstall sql 2k5?
>
> Thanks,
> Shawn
>
>|||> If 'SQL Server' is not listed on the 'Service Type' column then you do not
> have an instance of SQL Server 2005. You could install a new one.
How? Do I pop in the SQL Server 2005 (Server) disk? (as opposed to the
tools disk?). I've been spending hours and endless Google searches to
answer that very question and the answer is not clear (unless I'm using SQL
Express, which I'm not).
Thanks,
Shawn|||Hi Shawn,
Yes, install a new instance from your SQL Server 2005 media (in my case it
is SQL Server 2005 X Edition Disk 1'. Run setup and make sure you select 'SQL
Server Database Services' on the 'Components to Install' window.
If you already have a SQL Server 2000 default instance you can install a new
named instance for SQL Server 2005.
Installing SQL Server 2005 Service Pack 1 is a good idea too.
Hope this helps,
Ben Nevarez, MCDBA, OCP
Database Administrator
"Shawn B." wrote:
> > If 'SQL Server' is not listed on the 'Service Type' column then you do not
> > have an instance of SQL Server 2005. You could install a new one.
> How? Do I pop in the SQL Server 2005 (Server) disk? (as opposed to the
> tools disk?). I've been spending hours and endless Google searches to
> answer that very question and the answer is not clear (unless I'm using SQL
> Express, which I'm not).
>
> Thanks,
> Shawn
>
>|||> Yes, install a new instance from your SQL Server 2005 media (in my case it
> is SQL Server 2005 X Edition Disk 1'. Run setup and make sure you select
> 'SQL
> Server Database Services' on the 'Components to Install' window.
> If you already have a SQL Server 2000 default instance you can install a
> new
> named instance for SQL Server 2005.
> Installing SQL Server 2005 Service Pack 1 is a good idea too.
Done. That's all it was.
Thanks,
Shawn
I originally have had SQL 2k SP3 installed before installing Visual Studio
2005 and SQL Server 2005. Anyway, that was a while ago. Now, for the first
time in a blue moon I have the need to be doing some SQL Server 2005 stuff
on my machine and the only server that SQL Server Management Studio finds or
connects to on this box is version 8.0.760. I can swear I had set up a 2k5
database in the past and did some work with it. I have installed SQL 2k5
Developer Edition.
My main question is, how do I connect to the 2k5 database, and if need be,
how do I add one so I can connect to it? This should be simple but it seems
not.
Thanks,
ShawnProbably you still have your SQL Server 2000 instance installed, and if you
worked with a SQL Server 2005 instance before on the same computer, most
likely this is a named instance.
Run SQL Server 2000 Service Manager and click the Server list to see the
installed instances (I can even see SQL Server 2005 instances there).
Run SQL Server 2005 Configuration Manager and look into SQL Server 2005
Services.
Hope this helps,
Ben Nevarez, MCDBA, OCP
Database Administrator
"Shawn B." wrote:
> Greetings,
> I originally have had SQL 2k SP3 installed before installing Visual Studio
> 2005 and SQL Server 2005. Anyway, that was a while ago. Now, for the first
> time in a blue moon I have the need to be doing some SQL Server 2005 stuff
> on my machine and the only server that SQL Server Management Studio finds or
> connects to on this box is version 8.0.760. I can swear I had set up a 2k5
> database in the past and did some work with it. I have installed SQL 2k5
> Developer Edition.
> My main question is, how do I connect to the 2k5 database, and if need be,
> how do I add one so I can connect to it? This should be simple but it seems
> not.
>
> Thanks,
> Shawn
>
>|||> Probably you still have your SQL Server 2000 instance installed, and if
> you
> worked with a SQL Server 2005 instance before on the same computer, most
> likely this is a named instance.
> Run SQL Server 2000 Service Manager and click the Server list to see the
> installed instances (I can even see SQL Server 2005 instances there).
> Run SQL Server 2005 Configuration Manager and look into SQL Server 2005
> Services.
>
It does not show any SQL Server 2005 instances. Only the 2000 instance on
this machine and the 2000 instance on another machien. If it isn't showing
any 2005 instances running, how do I start it up? When I run SQL Server
2005 config man. everything seems as if 2005 is okay.
Thanks,
Shawn|||Try SQL Server Configuration Manager and select SQL Server 2005 Services.
Then look for the lines showing 'Service Type' as 'SQL Server'. There you
will see the instance name on the 'Name' column and you could check 'State'
to see if the instance is running or stopped.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Shawn B." wrote:
> > Probably you still have your SQL Server 2000 instance installed, and if
> > you
> > worked with a SQL Server 2005 instance before on the same computer, most
> > likely this is a named instance.
> >
> > Run SQL Server 2000 Service Manager and click the Server list to see the
> > installed instances (I can even see SQL Server 2005 instances there).
> >
> > Run SQL Server 2005 Configuration Manager and look into SQL Server 2005
> > Services.
> >
> It does not show any SQL Server 2005 instances. Only the 2000 instance on
> this machine and the 2000 instance on another machien. If it isn't showing
> any 2005 instances running, how do I start it up? When I run SQL Server
> 2005 config man. everything seems as if 2005 is okay.
>
> Thanks,
> Shawn
>
>|||> Try SQL Server Configuration Manager and select SQL Server 2005 Services.
> Then look for the lines showing 'Service Type' as 'SQL Server'. There you
> will see the instance name on the 'Name' column and you could check
> 'State'
> to see if the instance is running or stopped.
Well, there's my problem... I do not have "SQL Server" but I have a crap
load of others. How do I get the "SQL Server" service to appear? Should I
reinstall sql 2k5?
Thanks,
Shawn|||If 'SQL Server' is not listed on the 'Service Type' column then you do not
have an instance of SQL Server 2005. You could install a new one.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Shawn B." wrote:
> > Try SQL Server Configuration Manager and select SQL Server 2005 Services.
> > Then look for the lines showing 'Service Type' as 'SQL Server'. There you
> > will see the instance name on the 'Name' column and you could check
> > 'State'
> > to see if the instance is running or stopped.
> Well, there's my problem... I do not have "SQL Server" but I have a crap
> load of others. How do I get the "SQL Server" service to appear? Should I
> reinstall sql 2k5?
>
> Thanks,
> Shawn
>
>|||> If 'SQL Server' is not listed on the 'Service Type' column then you do not
> have an instance of SQL Server 2005. You could install a new one.
How? Do I pop in the SQL Server 2005 (Server) disk? (as opposed to the
tools disk?). I've been spending hours and endless Google searches to
answer that very question and the answer is not clear (unless I'm using SQL
Express, which I'm not).
Thanks,
Shawn|||Hi Shawn,
Yes, install a new instance from your SQL Server 2005 media (in my case it
is SQL Server 2005 X Edition Disk 1'. Run setup and make sure you select 'SQL
Server Database Services' on the 'Components to Install' window.
If you already have a SQL Server 2000 default instance you can install a new
named instance for SQL Server 2005.
Installing SQL Server 2005 Service Pack 1 is a good idea too.
Hope this helps,
Ben Nevarez, MCDBA, OCP
Database Administrator
"Shawn B." wrote:
> > If 'SQL Server' is not listed on the 'Service Type' column then you do not
> > have an instance of SQL Server 2005. You could install a new one.
> How? Do I pop in the SQL Server 2005 (Server) disk? (as opposed to the
> tools disk?). I've been spending hours and endless Google searches to
> answer that very question and the answer is not clear (unless I'm using SQL
> Express, which I'm not).
>
> Thanks,
> Shawn
>
>|||> Yes, install a new instance from your SQL Server 2005 media (in my case it
> is SQL Server 2005 X Edition Disk 1'. Run setup and make sure you select
> 'SQL
> Server Database Services' on the 'Components to Install' window.
> If you already have a SQL Server 2000 default instance you can install a
> new
> named instance for SQL Server 2005.
> Installing SQL Server 2005 Service Pack 1 is a good idea too.
Done. That's all it was.
Thanks,
Shawn
Sunday, February 12, 2012
Alternatives to builtin graphs
Is there any possible way to bundle my reports with references to other
controls to build a visual representation of data? I realize that this is
all informational, but I've got a problem with the stock graphs, they look
HORRIBLE.
Anyway, thanks in advance
WestonNot with this version. I gather the next version will have more options
along this line (release date in November).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Weston Weems" <wweems@.NOSPAMno-span-gmail.com> wrote in message
news:eR18CVagFHA.2444@.tk2msftngp13.phx.gbl...
> Is there any possible way to bundle my reports with references to other
> controls to build a visual representation of data? I realize that this is
> all informational, but I've got a problem with the stock graphs, they look
> HORRIBLE.
> Anyway, thanks in advance
> Weston
>
controls to build a visual representation of data? I realize that this is
all informational, but I've got a problem with the stock graphs, they look
HORRIBLE.
Anyway, thanks in advance
WestonNot with this version. I gather the next version will have more options
along this line (release date in November).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Weston Weems" <wweems@.NOSPAMno-span-gmail.com> wrote in message
news:eR18CVagFHA.2444@.tk2msftngp13.phx.gbl...
> Is there any possible way to bundle my reports with references to other
> controls to build a visual representation of data? I realize that this is
> all informational, but I've got a problem with the stock graphs, they look
> HORRIBLE.
> Anyway, thanks in advance
> Weston
>
Thursday, February 9, 2012
Alternative to Identity Help.
I have a SSIS package that imports an Excel file using Visual Basic 2005 into my SQL 2005 database. All the fields are the same in the DB and xls. The package runs with no problem but I need one of the fields to be autoincrement. I tried to set up the properties of one of my fields "ID" to be an Identity. This didn't seem to work at all. There are about 1300 records in the DB so far with the last "ID" number being 10001415. Before now, the numbers were inputed manually. I want the "ID" to be assigned when the SSIS package imports the xls file.
Any help is very appreciated.
See if this helps:http://www.ssistalk.com/2007/02/20/generating-surrogate-keys/|||
Not really. I opened the SQL Server Management Studio and tried to edit the DTSX package. I couldn't find any of those options you mention in the article. I am not that familiar with SSIS. I just used the wizard to create it.
|||I think all you have to do is to set a column in the target table to be an Identity (Identity Specification = Yes).
BTW, to edit a ssis package you have to use Business Intelligence Studio.
|||I previously set my column to Identity = Yes. When I run my DTSX package I get an error. It will not let me change a current column to identity and then import new data into the column. I tried creating a new column whith the Is Identity set to Yes with the appropriate seed and increment, however, I have records that have been deleted and now the numbering is off from the original format. What I mean is I have records numbered 1, 2, 3, 5, 6, 9, 12, etc in the DB in that order. When I create the new column and set the ID, it is unaware that I have records missing and what I end up with is 1, 2, 3, 4, 5, 6, etc.
I also tried creating a new SSIS package in order to use surrogate ID's and cannot figure out how to implement that within my import from Excel.
Please help!
|||
ISSOA wrote:
I previously set my column to Identity = Yes. When I run my DTSX package I get an error. It will not let me change a current column to identity and then import new data into the column.
If you want to insert explicit values in a identity colum you have to alter the table:
SET IDENTITY_INSERT <tableName> ON
|||I set all that up and I still get an error that I have violated the constraints for the column. The column that I am importing from EXCEL is blank. I want it to get a number when it is imported by the DTSX job. When I put a number in that column within the EXCEL sheet the number stays the same. Any ideas?
|||
I set all that up and I still get an error that I have violated the constraints for the column. The column that I am importing from EXCEL is blank. I want it to get a number when it is imported by the DTSX job. When I put a number in that column within the EXCEL sheet the number stays the same. Any ideas?
Don't map that column to the destination column. Leave it out of the Import/Export Wizard and you should get the results you desire.
Alternative to Identity Help.
I have a SSIS package that imports an Excel file using Visual Basic 2005 into my SQL 2005 database. All the fields are the same in the DB and xls. The package runs with no problem but I need one of the fields to be autoincrement. I tried to set up the properties of one of my fields "ID" to be an Identity. This didn't seem to work at all. There are about 1300 records in the DB so far with the last "ID" number being 10001415. Before now, the numbers were inputed manually. I want the "ID" to be assigned when the SSIS package imports the xls file.
Any help is very appreciated.
See if this helps:http://www.ssistalk.com/2007/02/20/generating-surrogate-keys/|||
Not really. I opened the SQL Server Management Studio and tried to edit the DTSX package. I couldn't find any of those options you mention in the article. I am not that familiar with SSIS. I just used the wizard to create it.
|||I think all you have to do is to set a column in the target table to be an Identity (Identity Specification = Yes).
BTW, to edit a ssis package you have to use Business Intelligence Studio.
|||I previously set my column to Identity = Yes. When I run my DTSX package I get an error. It will not let me change a current column to identity and then import new data into the column. I tried creating a new column whith the Is Identity set to Yes with the appropriate seed and increment, however, I have records that have been deleted and now the numbering is off from the original format. What I mean is I have records numbered 1, 2, 3, 5, 6, 9, 12, etc in the DB in that order. When I create the new column and set the ID, it is unaware that I have records missing and what I end up with is 1, 2, 3, 4, 5, 6, etc.
I also tried creating a new SSIS package in order to use surrogate ID's and cannot figure out how to implement that within my import from Excel.
Please help!
|||
I previously set my column to Identity = Yes. When I run my DTSX package I get an error. It will not let me change a current column to identity and then import new data into the column.
If you want to insert explicit values in a identity colum you have to alter the table:
SET IDENTITY_INSERT <tableName> ON
|||I set all that up and I still get an error that I have violated the constraints for the column. The column that I am importing from EXCEL is blank. I want it to get a number when it is imported by the DTSX job. When I put a number in that column within the EXCEL sheet the number stays the same. Any ideas?
|||
I set all that up and I still get an error that I have violated the constraints for the column. The column that I am importing from EXCEL is blank. I want it to get a number when it is imported by the DTSX job. When I put a number in that column within the EXCEL sheet the number stays the same. Any ideas?
Don't map that column to the destination column. Leave it out of the Import/Export Wizard and you should get the results you desire.
Subscribe to:
Posts (Atom)