SQL Server 2005 Initialization Suggestions?
Jun 28, 2006
Greetings all,
I have a SQL Server 2005 Database for a product based solution which needs to be initialized with some basic info before it get's shipped along with the product. For example, the default admin password and assigning it to the Administrator role (Membership API). Additionally some other application specific info.
My first thought would be to create a command line utility which would be executed just once that reads a text file definining what needs to go where and blow this into an empty database. I discovered the SSEUtil which could be handy but I understand this tool works only with SQL Express.
Can someone suggest a strategy for handling this scenario?
Thanks in advance!
View 1 Replies
ADVERTISEMENT
Jun 8, 2006
Hi there,
I'm trying to initialize a subscription for a transactional replication between Oracle9i and MS SQL Server 2005.
The snapshot agent runs succesfully, but I get an error when the distribution agent runs to apply the snapshots at the subscriber. I've pastet the job history from the Log File Viewer below.
Message
2006-06-08 09:27:25.516 Applied script 'ADDRESS_8.sch'
2006-06-08 09:27:25.516 Applied script 'ADDRESS_8.idx'
2006-06-08 09:27:25.516 Bulk copying data into table 'ADDRESS'
2006-06-08 09:27:25.641 Agent message code 20037. The process could not bulk copy into table '"ADDRESS"'.
2006-06-08 09:27:25.704 Category:NULL
Source: Microsoft SQL Native Client
Number:
Message: Data conversion failed
2006-06-08 09:27:25.704 Category:NULL
Every column contaning null-values at the table in Oracle9i is allowing null-values at the destination table in the SQL Server.
I'm pretty lost here - does anyone know how to solve this problem?
Best regards,
JB Plum
View 6 Replies
View Related
May 24, 2006
hi,
i am working on a website that will be storing millions of images. i have read various advantages/disadvantages of saving the images on sql vs. file system.
i would like to keep all the data in one location (sql server in this case), so what i had in mind is following:i am going to save the original image data on a sql server. now, the website user can view a (multiple) thumbnail version(s) of the original image and the orig. image itself, so instead of getting the original image from sql and resizing it everytime, i was going to create a file(s) on a sep. server with the resized image(s) that would be called instead (think of it as file-cache). this would reduce the load on the sql server drastically since all the thumbnails (and orig. image) would have the file version of themselfes and would be loaded from the separate server. this way i could have all my data on a sql server, have thumbnail images on an "image server" and everything should be fine with the exception of the increased disk space. Also, i would not have to worry about having 2 backups since i have all the data on sql and each image/thumbnail would be file-cached on it's first call. if the file-cache of the image is not available for whatever reason i would just load straight from the db.
i would appreciate any suggestions on this.
thanks :)
View 2 Replies
View Related
Jan 14, 2007
Hi guys , is there any ways/suggestions for strengthen up the security for SQL server 2005 ? Due to several attacks from unknown places to my database's server , so I would like to get a way for increase the SQL security. Hope able to gather some info from web as well. Thx a lot guys.
Best Regards,
Hans
View 5 Replies
View Related
Oct 20, 2007
Hi all,
I know there's been quite a bit of discussion on WHETHER to run antivirus software on a SQL box(http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1764423&SiteID=1).
If I do decide to run it, does anyone have suggestions of specific antivirus software that have worked well and did not cause significant performance problems?
Thanks in advance.
--Jim
View 1 Replies
View Related
Sep 7, 2006
OK we currently have a single SQL 2000 Server for our DW with a DR SQL 2000 Server. We are wanting to create a setup where we have a Failover Cluster of SQL 2005 here at the main office with a DR SQL 2005 system at our DR site. My question is... How would you all do the failover and stuff? How many servers would I need and what would be the job/role for each server. Some things to take note we are implimenting a SAN in our network and we are also implimenting a Virtual Server system on our network. To my understanding you do not really wish to run SQL Servers on a Virtual machine if possible. So I am already planning on making the SQL Servers Physical systems. We are also planning on putting the DB's on the SAN and have the SAN replicate all the data to DR. So... How would you all invision things to be setup? Is there any good documentation I can read about this type of setup. Thank you in advance for all the advice you can provide.
Thanks,
Billy S.
View 4 Replies
View Related
Jan 31, 2007
I've seen other posts on this topic, but not with error 0x32.
I was attempting to change a CLUSTERED instance of SQL 2005 from dynamic port to static port and in the process have somehow messed it up to the point it will no longer start. Version is 9.00.2047.00
The ERRORLOG has the following
2007-01-31 15:02:05.77 spid9s Starting up database 'model'.
2007-01-31 15:02:05.77 Server Error: 17182, Severity: 16, State: 1.
2007-01-31 15:02:05.77 Server TDSSNIClient initialization failed with error 0x32, status code 0x1c.
2007-01-31 15:02:05.77 Server Error: 17182, Severity: 16, State: 1.
2007-01-31 15:02:05.77 Server TDSSNIClient initialization failed with error 0x32, status code 0x1.
2007-01-31 15:02:05.77 Server Error: 17826, Severity: 18, State: 3.
2007-01-31 15:02:05.77 Server Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
2007-01-31 15:02:05.77 Server Error: 17120, Severity: 16, State: 1.
2007-01-31 15:02:05.77 Server SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.
The values have only been changed using SQL Server Configuration Manager (no direct registry changes have been made).
Thanks for you help.
View 1 Replies
View Related
Nov 20, 2006
I have this SP that takes several varchar columns and concatinates them all together then inserts them into a text field. I do this with a cursor which was the quickest way to get it done when it was setup...
However when I moved the process to a 2005 server (on the same physical server) the process drastically slowed down. On 2000 the process took about 7 min to handle all 350k+ rows with the processors hanging around 20-40%... On 2005 it took over 30 min (not sure how long it would take cause I killed the process) and the processors stay above 98%...
I have rewritten the process to use a while loop instead of the cursor (I wanted to do this anyways) and it had no effect. At this rate (about 1 row a second) it will take forever and this process runs everyday.
Any ideas??
Here is the procedure...
declare @srch_field varchar(8000)
declare @row int, @productid varchar(25)
DECLARE @title varchar(150), @actors_keyname varchar(1200), @directors_name varchar(400)
Declare @genres varchar(700), @theme varchar(1500), @type varchar(1500), @studio_desc varchar(100)
DECLARE @media_format varchar(50), @artist_name varchar(100), @dev_name varchar(100)
DECLARE @flags varchar(256), @starring varchar(256), @esrb varchar(100), @esrb_desc varchar(500)
DECLARE @ptrval varbinary(16), @text varchar(max)
declare @productlist table(product_id varchar(25), IDNUM int identity)
insert into @productlist (product_id)
select product_id
from music_load..globalsearch
select @row = @@rowcount
while @row > 0
begin
select @productid = product_id
from @productlist
where idnum = @row
SELECT @title = rtrim(title) ,
@actors_keyname = actors_keyname ,
@directors_name = directors_name,
@genres = genres ,
@theme = theme ,
@type = type ,
@studio_desc = studio_desc,
@media_format = media_format ,
@artist_name = artist_name,
@dev_name = dev_name,
@flags = flags ,
@starring =starring ,
@esrb = esrb ,
@esrb_desc = esrb_desc
FROM globalsearch
where product_id = @productid
Set @srch_field = isnull(@title,'')
if @actors_keyname is not null and @actors_keyname <> 'unknown'
Set @srch_field = @srch_field + ' ~ ' + rtrim(@actors_keyname)
if @directors_name is not null and @directors_name <> 'unknown'
Set @srch_field = @srch_field + ' ~ ' + rtrim(@directors_name)
if @genres is not null
Set @srch_field = @srch_field + ' ~ ' + (ltrim(rtrim(replace(@genres, 0,''))))
if @theme is not null
Set @srch_field = @srch_field + ' ~ ' + (ltrim(rtrim(replace(@theme, 0,''))))
if @type is not null
Set @srch_field = @srch_field + ' ~ ' + (ltrim(rtrim(replace(@type, 0,''))))
if @studio_desc is not null
Set @srch_field = @srch_field + ' ~ ' + rtrim(@studio_desc)
if @media_format is not null
Set @srch_field = @srch_field + ' ~ ' + rtrim(@media_format)
if @artist_name is not null
Set @srch_field = @srch_field + ' ~ ' + rtrim(@artist_name)
if @dev_name is not null
Set @srch_field = @srch_field + ' ~ ' + rtrim(@dev_name)
if @flags is not null
Set @srch_field = @srch_field + ' ~ ' + rtrim(@flags)
if @starring is not null
Set @srch_field = @srch_field + ' ~ ' + rtrim(@starring)
if @esrb is not null
Set @srch_field = @srch_field + ' ~ ' + rtrim(@esrb)
if @esrb_desc is not null
Set @srch_field = @srch_field + ' ~ ' + rtrim(@esrb_desc)
update globalsearch
set srch_field = @srch_field
where product_id = @productid
SELECT @ptrval = TEXTPTR(srch_field),
@text = credits
FROM globalsearch
where product_id = @productid
UPDATETEXT globalsearch.srch_field @ptrval NULL NULL @text
SELECT @ptrval = TEXTPTR(srch_field),
@text = track
FROM globalsearch
where product_id = @productid
UPDATETEXT globalsearch.srch_field @ptrval NULL NULL @text
set @row = @row - 1
end
View 5 Replies
View Related
Mar 21, 2008
Hello,
Background: I am a Software Engineer - not a DBA - with limited SQL knowledge (I know the SQL but not the configuration stuff)... I am sure others need this too - I tried but cannot find the answers online... please help me with a few questions:
Task: I need to find an way to install a database via Installshield 2008/command-line (silently), that is accessible locally and remotely regardless of what was already installed, and accessible only to our program - not users, so I am thinking use SA and a strong password since windows authentication may not apply with multiple users accessing this DB and they do not need to login on to the server - only our program does - sound right to use Mixed?).
Questions:
Can SQL 2005 Express be installed when SQL 2005 Full edition is already present?
Can SQL 2005 Express be installed without an instance name?
I think I read an instance name is required in Express, that if I do not provide it defaults to SQLEXPRESS -
So, if the prior question's answer is 'no, they cannot both exist'... prompting the next question:
If the Full version is already installed, should/can I use it - AND - can I add a New Instance silently via command line or ???
Any other ideas on why I can install 2005Express on one system, and not on two others (all 3 are development machines: VS 2005, SQL Express and that's about it)?
Currently I have figured out a command-line call to install - the command I came up with during testing is:
start /wait C: empSQLEXPR32.EXE /qb INSTANCENAME=CINST ADDLOCAL=ALL SECURITYMODE=SQL SAPWD=STR2PWD4SA SQLBROWSERACCOUNT="NT AUTHORITYNETWORK SERVICE" SQLACCOUNT="NT AUTHORITYNETWORK SERVICE" AGTACCOUNT="NT AUTHORITYNETWORK SERVICE" SQLBROWSERAUTOSTART=1 SQLAUTOSTART=1 AGTAUTOSTART=1 DISABLENETWORKPROTOCOLS=0 ERRORREPORTING=1 ADDUSERASADMIN=1
This looks like it might work for SQL Express 2005 - I do not have the full edition installed, yet - thus, this post.
The errors I got, shown in the summary.txt as 'Error 10' on one system with no other info.
My other system reports:
Microsoft SQL Server 2005 9.00.3042.00
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time : Fri Mar 21 16:45:25 2008
Machine : TONELSON
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.3042.00
Install : Successful
Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0007_TONELSON_SQLSupport_1.log
--------------------------------------------------------------------------------
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
...not much to go on as to why it is failing - maybe the hotfix:
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9Express_Hotfix_KB921896_SQLEXPR.EXE
in the directory is blocking the install?
The goal is for my application to use the same connection strings regardless of 2005 full or 2005 express.
Need to figure this out -
Thank you,
Todd
Software Engineer/Developer... learning a lot about SQL
View 6 Replies
View Related
Feb 8, 2005
Hi,
I am working on the guided tour of the ASP.NET WebMatrix tool, and I wanted to perform the section of connecting to a SQL server.
I downloaded SQL2kdesksp3 from the Microsoft website, extracted it, and followed the instructions for installing it:
setup SAPWD=(some password) SecurityMode=SQL
It installs all the way to the end, and I get an error message :
"Setup failed to initialize the server. Please see the setup error logs for more information"
I tried to reinstall it, and even tried downloading it again, and then running it, I get the same message.
Could someone tell me what is going on, or where to find the error logs?
Thanks in advance.
View 8 Replies
View Related
Jul 23, 2005
I am running McAfee ePO and SQL Server 2000 on a dual Xeon 900Mhz boxcurrently. It is slow. I am going to be ordering 2 new servers, 1 forePO and 1 for SQL Server 2000. Anybody have any suggestions for theSQL Server's hardware specs. Thanks,Chris
View 3 Replies
View Related
Mar 13, 2008
I am running Windows Server 2003 R2 standard Edition with SP1, using IIS, and SQL Server 2000 Enterprise Edition. Server running 4 core processors with 4CGB of RAM. I have not changed any entries to the boot.ini or with SQL Server to take advantage of the memory. I am looking for the best way to utilize the hardware in the machine????
This is dedicated DB server under split server configuration
Would it be useful if swith to /3g for AWE enabled option for sp_configure?
Please suggest me the best configuration methods if any
Thanks in advance,
View 4 Replies
View Related
Oct 26, 2007
Folks I have recently had the misfortune of moving to SQL Server Managment Studio as per our upgrade to SQL 2005. There is no doubt that SQL Server Management is a major disappoinment compared to Enterprise manager.
The UI is the biggest disaster I have ever seen. Getting rid of the SQL Query analyzer tool was a TERRIBLE idea. The UI is buggy and unfriendly. It is a major POS. I hope someone in the SQL Dev team is listening / reading this post (hellooooo anybody homeee......)
Now that I have vented my frustration ...
I wanted to know any atlernatives to the SQL Server Management Studio. There are plenty of 3rd Party tools out there I wanted to find out from this forum which popular 3rd Party tools are most developers using
Thanks for bearing with me.
View 7 Replies
View Related
Sep 17, 2006
Dear friends
I read about 'NoSync' initialization.I tried out in my system.That time after executing Sp_Scriptpublicationcustomprocs,Stored procedures are propagated to subscriber.Replication was working fine.But afterwards I got some problem.So I reinstall my SQL Server I agin tried 'NoSync' initialization.This time Stored procedure is getting created on Publisher database not in subscriber.Can you tell me what may be the reason
I have two other doubts also
1)Sometimes I am getting error in subscriber.'The process couldn't connect to Distributor'.How to configure distributor in this case?
in configure publishing,distributor wizard I won't able to do anything like that change distributor login or something
2)How to delete Distributor database from a server.once it's get created if wan't also I won't able to delete it
3)If I am using SQL Server 2005 Peer to peer Replication whether it will be reliable for load balancing.My All servers will be in one office only.Or clustering may be better technology for load balancing.if it is like that can you tell me why it is?
Expecting reply
Filson
View 1 Replies
View Related
Apr 11, 2006
Hello,
I have just installed SQL Server 2005 Enterprise Evaluation Edition and everything work except the report server.
I have no problems to configure reporting services but when the configuration is done, the initialization doesn't work.
I have the message :
"There was an internal error
while switching panels. The most likely cause is an error retriewing
WMI properties. the exeception details are: An internal error occured on report server. For more informations, consult the log files (rsInternalError)"
when i search in thr log files, i have different messages (various errors without meaning for me) :
"Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread()"
ReportingServicesService!library!8!11/04/2006-13:59:33:: Exception caught while starting service. Error: System.Threading.ThreadAbortException: Le thread a été abandonné.
à Microsoft.SqlServer.SqlDumper.Dumper..ctor()
à Microsoft.SqlServer.SqlDumper.DumpClient.GetDumper()
à Microsoft.ReportingServices.Diagnostics.Dumper.DumpHere(Exception optionalException, String assertionMessage)
à Microsoft.ReportingServices.Diagnostics.Utilities.RSException..ctor(ErrorCode errorCode, String localizedMessage, Exception innerException, RSTrace tracer, String additionalTraceMessage)
à Microsoft.ReportingServices.Diagnostics.Utilities.ReportCatalogException..ctor(ErrorCode errorCode, String localizedMessage, Exception innerException, String additionalTraceMessage)
à Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
à Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition()
à Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
à Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread()
View 4 Replies
View Related
Jul 24, 2007
Hi,
We had a healthy 2-way merge replication set up with a SQL 2005 publisher/distributor and a SQL 2000 subscriber which had been running for about a week. I re-created the publication so I could add automatic identity range management to an article. I sucessfully re-created a push subscription to a SQL 2005 subscriber but when I tried to create one to the same SQL 2000 machine that had been quite happy a few hours earlier, I kept getting this error during initialization: "bulk data stream was incorrectly specified as sorted". Nothing much has changed as far as I can see. Can anyone give me some pointers?
Thanks,
Pete
View 2 Replies
View Related
Feb 26, 2007
I have seen these terms used but don't understand exactly what they are and how they differ. Could I use one without the other or are they a "linked" pair?
TIA,
Barkingdog
View 6 Replies
View Related
Jul 16, 2007
I have been trying to use Instant File Initialization feature on one of the servers which is a part of DMZ. One of the requirement, I understand, for that feature to work is to have SQL Server configured to use NT Authentication. My server is running in Mixed authentication, using local administrator account. I understand I should practice principle of least privilege, but question at hand is how I could use instant file initialization when SQL Server is not using Domain account.
Thanks,
Asaf
View 3 Replies
View Related
Aug 10, 2007
Hi
I am trying to configure reporting services. When I try to connect the portal through browser, it gives following error
"The report server installation is not initialized. (rsReportServerNotActivated) (rsRPCError)"..
Any idea, why this error? Also, in reporting services configuration manager, the initialization tab is greyed. I need this to get solved as soon as possible. Please let me know how can I get this thing done.
Regards
Abhinav
View 1 Replies
View Related
Jul 18, 2007
Guys I noticed that the value I set on one of the package variables is not carried over during the execution. I have a package variable of type String which I use to hold the string for a parameter in a stored procedure. My stored procedure has one output parameter which is the id of the record fetched using the string parameter. These are my parameters
1) User::vendorId Int32 Initial value = -1
2) User::vendorName String Initial value = Vendor A
I make the assignment in the Variable pane. Are there any other ways of doing this?
Watching the two variables reveals that only the value for the first variable is carried over during execution. The vendorname is always blank --> {}. I'm using a SQL Task with OLEDBConnection.
What's going on here?
View 8 Replies
View Related
Feb 14, 2004
I have a web config file with the connection string to my db in it. The same connection string is used throughout my application.
I authenticate users via my own Login page - this page uses the connection string in the web config file, connects to the db and proceeds to log the user on (a record of access is stored within the db). It then redirects to a second page. This page uses the same connection string from the web config file but on the "open" I get the following error:
Error Message: System.InvalidOperationException: The ConnectionString property has not been initialized. at System.Data.SqlClient.SqlConnection.Open()
The dim in the code is always the same:
Dim cnMyConn As New SqlConnection(ConfigurationSettings.AppSettings("connectionString"))
and the open is:
cnMyConn.Open()
This only happens on my hosted site. When I run locally on my test machine the page is displayed fine???? I have connection pooling set on in the remote web config file.
The web config remotely looks like:
<add key="connectionString" value="Server=???;uid=???t;pwd=???;database=unifuturenet; min Pool Size=3; max Pool Size=5;pooling=True;" />
??? set to appropriate values.
within the code, the connection is set by:
Dim cnMyConn As New SqlConnection(ConfigurationSettings.AppSettings("connectionString"))
If anyone has any bright ideas, I would appreciate it. It may be worth mentioning that I am running version 1.0.3705 and I have this in the remote web config file:
- <startup>
<supportedRuntime version="v1.0.3705" />
</startup>
Kind regards,
Rob
View 2 Replies
View Related
Apr 14, 2005
Hi all,
Complete newbie to ASP.NET, but you have to learn some time. Anyway, I am attempting to fill a datagrid from the Northwind database installed on my SQL server at work and I receive the following error when I attempt to compile to check the connection.
Format of the initialization string does not conform to specification starting at index 67.
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.ArgumentException: Format of the initialization string does not conform to specification starting at index 67.Source Error:
Line 31:
Line 32: Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Line 33: Dim cnn As New SqlConnection( _
Line 34: "Data source=xxxxx;Initial Catalog=Northwind;User ID=sa;Password=;xxxxxx")
Line 35: End SubSource File: C:InetpubwwwrootApp_02default.aspx.vb Line: 33 Stack Trace:
[ArgumentException: Format of the initialization string does not conform to specification starting at index 67.]
System.Data.Common.DbConnectionOptions.GetKeyValuePair(String connectionString, Int32 currentPosition, StringBuilder buffer, String& keyname, String& keyvalue) +1203
System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey) +127
System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useFirstKeyValuePair) +103
System.Data.SqlClient.SqlConnectionString..ctor(String connectionString) +32
System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous) +25
System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String connectionString, DbConnectionPoolOptions poolOptions, DbConnectionOptions& userConnectionOptions) +119
System.Data.ProviderBase.DbConnectionBase.set_ConnectionString(String value) +53
System.Data.SqlClient.SqlConnection.set_ConnectionString(String value) +7
System.Data.SqlClient.SqlConnection..ctor(String connectionString) +23
App_02.WebForm1.Page_Load(Object sender, EventArgs e) in C:InetpubwwwrootApp_02default.aspx.vb:33
System.Web.UI.Control.OnLoad(EventArgs e) +102
System.Web.UI.Control.LoadRecursive() +45
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +952
I have been tearing my hair out trying to work out this error. Can anyone help????
Using VisualStudio.NET 2003 on an XP box and and SQL Server 2000 on a Windows2003 Server box.
Thanks,
Gerald
View 1 Replies
View Related
Mar 29, 2007
I am installing sql server 2005 reporting services on server running sql server 2005. I get to the reporting services configuration page and configure...
report server virtual directory
report manager virtual directory
windows service identity
web service identity
database setup
encryption keys
when I get to Initialization the button is grey and inactive so I can't initialize reporting
services, Do I need to restart server?
View 1 Replies
View Related
Jul 14, 2015
when have had a problem in the initialization of a Merge replication of 3.600.000 rows on SQL Server 2014.The sp_MSmakegeneration was generating a large number of X locks and the replication process was unable to start.Finally we solved the issue modifying thegeneration_leveling_threshold parameter to 0..But, by knowledge this was a known issue with older SQL Server Version.if is mandatory to set it to 0 due to ininizialize large Relicas?
View 3 Replies
View Related
Feb 23, 2006
I installed the evaluation version of SQL Server 2005 to my Windows XP machine. Everything has worked well. Now I have problem. I installed the reporting service to test the web reporting.
In the Report service configuration manager I get three errors:
The Web Services Identity indicator is red and pushing Apply button gives the error:ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error has occurred in the WMI Provider. Error Code 8007056B
Pushing Initialization button gives the message: There was an error while switching panels. The most likely cause is an error retriewing WMI properties. the exeception details are: An error occured when attempting to connect to the report server remote procedure call (RPC) end point. Verify that the Report Server Windows service is running and then try the operation. Execption 800706B3.
Server Status Indicator is also red. Pushing the Start Button gives the following message: System.ServiceProcess.TimeoutException: Time out has expired and the operation has not been completed. at System.ServiceProcess. ServiceController. WaitForStatus(ServiceControllerStatus desiredStatus, TimeSpan timeout) at ReportServicesConfigUI.Panels.ServerInformationPanel.StartStopServiceTask(Boolean start)
Has anyone an idea what I should do ??
thankfully
Matti
View 27 Replies
View Related
Jul 23, 2007
I guess this may not strictly be a CLR integration question, because what I'm actually doing is using sp_OACreate in a T-SQL batch to call a COM object written in C#. Not as nice as using full CLR integration, but unfortunately the T-SQL must run without error on a SQL 2000 server before it is upgraded to 2005, and I preferred this option to using reams of dynamic SQL.
The first call to sp_OACreate fails with hRes 0x80131022. MSSQLServer also logs the following error to the app event log:
"Failed to initialize the Common Language Runtime (CLR) v2.0.50727 with HRESULT 0x80131022. You may fix the problem and try again later."
Please can anyone suggest why this is happening? I've tried repairing the .NET framework (v2) installation, and reinstalled SQL Server Express. I've double checked both CLR integration and OLE Automation are allowed in the Surface Area config tool for SQL Express. I've tried running SQL Express using both LocalSystem and the administrator account on the machine. I've even checked there is plenty of free memory (including virtual memory). Nothing has helped though.
Thanks in advance for any help or suggestions you can provide,
Rob
View 5 Replies
View Related
Jan 6, 2015
My 3rd party backup product uses a non-service account login to perform tasks. If the account that it uses has been granted Perform Volume Maintenance tasks on the server, will it use IFI when restoring? Or do I need to have it use the service account login specifically to benefit from that?
View 2 Replies
View Related
Feb 13, 2015
I have configured three transactional replication one from DC - Data center & DB for database
DC1-DB1 to DC2-DB1 -- 1
DC2-DB1 to DC2-DB2 --2
DC2-DB2 to -DC2-DB3 --3
Before synching the data on DC2 databases I wanted to truncate / drop the objects on 1 and 2 setup as these are already participating in replication. Setup 1 and 2 are publisher as well as subscriber. I am not able to reinitialize these tables on these setup. I cannot use SSIS.
View 3 Replies
View Related
Jan 5, 2006
Hi all,
Is it possible to create a trigger after creation of table during reinitialization? if so, how can I do that? Thanks in advance!
View 11 Replies
View Related
Mar 5, 2008
Howdy Folks!
I'd like to put all the properties from the DBPROPSET_SSCE_DBINIT propset into a configuration file (XML probably) such that I can read in and dynamically adjust my SSCE connections. This way stuff like max database size and buffer size can be changed without a recompile.
My idea was to have an XML in the form:
<PropertySet Id = DBPROPSET_SSCE_DBINIT>
<Property Id = DBPROP_SSCE_AUTO_SHRINK_THRESHOLD>
<Options>DBPROPOPTIONS_REQUIRED</Options>
<Type>VT_I4</Type>
<Value>100</Value>
</Property>
<Property Id = DBPROP_SSCE_MAX_DATABASE_SIZE>
<Options>DBPROPOPTIONS_REQUIRED</Options>
<Type>VT_I4</Type>
<Value>1024</Value>
</Property>
.
.
.
</PropertySet>
Now my question is...can y'all think of any better way to convert these strings that I'll retrieve (e.g. "DBPROP_SSCE_MAX_DATABASE_SIZE") to their enum'd equivalents than to do the following:
if(PropertId == L"DBPROP_SSCE_AUTO_SHRINK_THRESHOLD") return DBPROP_SSCE_AUTO_SHRINK_THRESHOLD;
if(PropertId == L"DBPROP_SSCE_MAX_DATABASE_SIZE") return DBPROP_SSCE_MAX_DATABASE_SIZE;
It's seems entirely too unelegant and wasteful...but maybe I'm being too picky. It also has the disadvantage of needing to be updated if more properties are added with subsequent versions.
What do y'all think? Thanks as always!
View 5 Replies
View Related
Aug 15, 2007
When opening Visual Studio 2005 and creating a new project my computer sometimes crashes (blue screen).
The System Error with source MSSQL$SQLEXPRESS and description: Fallback certificate initialization failed. Error: 1 (Event-ID: 17190) is found in the programlog.
Do anyone know the source of this error/what is causing it? How can I fix it?
Regards,
Lotta
View 1 Replies
View Related
Feb 5, 2008
In Server Explorer I am trying to add a data connection for OUR database using OUR own ole db data provider. Procedure below-
1. Right click "Data Connections"
2. Click "Add Connection...", "Change Data Source" dialog is displayed.
3. Select "other" and ".NET Framework Data Provider for OLE DB". Click OK. "Add Connection" dialog is displayed.
4. Select "OLE DB Provider". I selected OUR provider.
5. Edit necessary properties. Click OK.
6. An error dialog is displayed saying "Format of the initialization string does not conform to the OLE DB specification."
If I go back to the "Add Connection" dialog(after clicking OK on error) and click "Advanced", I see connection string as--
Provider=OURPROVIDER;Data Source=our_backend;Password=password;User ID=admin;Initial Catalog=mydb
I am not able to find out what/where went wrong. I tried this conneciton string in a c# program, it works perfectly fine.
Can anyone help me on why I am getting this error with our provider in SSIS?
Thanks,
Vivek.
View 3 Replies
View Related
Mar 12, 2008
Hi,
Basically the above is a very common requirement, please comment on my solution which I've arrived at by searching through the web; -
In summary I have used 3 SSIS components these are "Flat File Source", "Derived Column" and "SQL Server Destination".
1) File Connections Manager Editor
1.1) Within File Connections Manager Editor; -
Name the data type e.g. "INTERCHANGE_NET_APP_DATE_SRC"
and assign a type to the data type e.g. string[DT_STR]
1.2) Click on the Preview button to ensure the expected text is assigned to the expected data type.
2) Derived Column Transformation Editor
2.1) Assign Derived Column Name, e.g.
INTERCHANGE_NET_APP_DATE
2.2) Select <add as new column> within Derived Column.
2.3) Enter the conversion Expression, e.g. ; -
2.3.1)
(SUBSTRING(INTERCHANGE_NET_APP_DATE_SRC,8,2) + "/" + SUBSTRING(INTERCHANGE_NET_APP_DATE_SRC,5,2) + "/" + SUBSTRING(INTERCHANGE_NET_APP_DATE_SRC,1,4))
2.3.2)
Since the above conversion is such a common task I suggest that Service Pack 3 of SQL Server 2005 delivers the following functionality; -
STRINGTODATE ('YYYYMMDD',INTERCHANGE_NET_APP_DATE_SRC)
2.4) Select "database timestamp [DT_DBTIMESTAMP] " as Data Type.
2.5) Within the Mappings tab of the SQL Destination Editor have; -
Input Column as INTERCHANGE_NET_APP_DATE and
Destination Column as INTERCHANGE_NET_APP_DATE.
Please comment on the above, I will then pass on my suggestion to Microsoft.
Thanks in advance,
Kieran.
View 1 Replies
View Related
