My company is going through a conversion that will eventually use Microsoft SQL Server 7.0 as its database platform. When it was originally installed, the data was installed on the system drive (C:) rather than our raid 5 configuration (the D: located on the same server). This was not known until after development had started taking place. We were able to export all the data and its corresponding objects to a standalone version of SQL so that we could uninstall the previous version of SQL onour server. We uninstalled SQL 7.0 and then reinstalled it, telling it to install the data files onto the raid 5 configuration (D:). The installation appears to run fine until it gets to the point where it wants to connect to SQL Server. At this point it pauses, states that the Connect fails and retries only to stop with an error message stating that the it could not connect to the server. I check my confgsvr.out file and it basically states that the server configuration failed. So I reinstalled SQL with the data residing on the system drive and everything works correctly. The question I have is there some registry setting that I have to change prior to installing SQL to allow it to install the data files onto the network (raid 5 drive system)? Or is there anything else I should be looking at as to why this happens? Thank you very much in advance for any assistance that can be provided.
Sean McLaughlin